TPC-E基准测试中BrokerVolume事务在Oracle存储过程中的实现

--尝试一下以数组传入，以字符串传出
create or replace type broker_array_t as varray(40) of varchar2(100);
create or replace type BROKER_ARRAY as table of varchar2(100)；
create or replace type VOLUME_ARRAY as table of number(10,2);
-- 
CREATE GLOBAL TEMPORARY table bv (
bname varchar2(100),
volu number(10,2))
    ON COMMIT DELETE ROWS
--
create or replace
procedure BrokerVolume(
 broker_list in BROKER_ARRAY,--broker_array_t,
 sector_name in varchar2,
 broker_name out varchar2,  --array
 list_len out integer,
 bv_status  out integer,
 volume  out varchar2  --array
 )
 as
  i integer;
  b_na varchar2(100);
  vol number(10,2);
  broker_name_list broker_array_t;-- broker_array_t;
 type volume_array is varray(40) of number(10,2);
  volume_list volume_array; --VOLUME_ARRAY;
  type cur_type is ref cursor;
  cur cur_type;
 --?????
 --CREATE GLOBAL TEMPORARY table bv (