oracle数据库之数组的操作样例

1.创建bean对象

--创建bean对象
CREATE OR REPLACE TYPE "FM_FLOWCPHDTSWJJIMPBEAN"    as object
(
  wf_no varchar2(256),
  wf_priority_level varchar2(256)
)

2.创建基于bean的数组

--创建基于bean的数组
CREATE OR REPLACE TYPE "FM_FLOWCPHDTSWJJIMPARRAY"  is table of FM_FLOWCPHDTSWJJIMPBEAN

3.存储过程的实现

--存储过程的实现
procedure fm_cphd_updatewjjpllist(import_data FM_FLOWCPHDTSWJJIMPARRAY) IS
    v_bean FM_FLOWCPHDTSWJJIMPBEAN;
  BEGIN
    for i in import_data.first .. import_data.last loop
      v_bean := import_data(i);
      update fm_flow_cphd_ts_wjj t
         set t.wf_priority_level = (select value
                                      from fm_flow_pz_combo
                                     where pz_id = 71
                                       and name = v_bean.wf_priority_level)
       where wf_id =
             (select wf_id from fm_flow_bill where wf_no = v_bean.wf_no);
    end loop;
  END fm_cphd_updatewjjpllist;