在包头里定义了嵌套表数组,
作为包内函数的入参和出参。
包头文件如下:
CREATE OR REPLACE PACKAGE SYSTEM.GM01B1
IS
TYPE vrcArray1 IS TABLE OF VARCHAR2(1)index by binary_integer;
TYPE vrcArray2 IS TABLE OF VARCHAR2(2)index by binary_integer;
TYPE vrcArray3 IS TABLE OF VARCHAR2(16) index by binary_integer;
TYPE vrcArray4 IS TABLE OF VARCHAR2(30) index by binary_integer;
TYPE numArray1 IS TABLE OF VARCHAR2(30) index by binary_integer;
FUNCTION FNC_MSTRENKEI (
inLoginId
INvarchar2,
inKb_kido
INvarchar2,
inKb_syori
INvarchar2,
inCd_joho_group
INvrcArray2,
outErrCode
OUT varchar2,
outItem
OUT varchar2,
outCd_joho_group
OUT vrcArray2,
outId_table
OUT vrcArray4,
outSyori_cnt
OUT numArray1,
outSyori_date
OUT vrcArray3,
outSyori_kekka
OUT vrcArray1
) RETURN VARCHAR;
END;
使用pl/sql develop工具做调试的时候,数组参数inCd_joho_group,outCd_joho_group,outId_table ,outSyori_cnt,outSyori_date,outSyori_kekka. 不显示,没法输入。
请教对于这种使用数组做参数的package如何调试啊?
|