CREATE OR REPLACE PACKAGE TOS_SP_APPCOMMENTMNGDATA AS
TYPE AssocArrayChar_t IS TABLE OF CHAR INDEX BY BINARY_INTEGER;
TYPE AssocArrayVarchar2_t IS TABLE OF VARCHAR2(1024) INDEX BY BINARY_INTEGER;
TYPE AssocArrayNVarchar2_t IS TABLE OF NVARCHAR2(60) INDEX BY BINARY_INTEGER;
TYPE CursorType IS REF CURSOR;
TYPE AssocArrayDate_t IS TABLE OF DATE INDEX BY BINARY_INTEGER;
PROCEDURE SET_APPCOMMENTMNGDATA(
V_APP_TYPE IN AssocArrayVarchar2_t,
V_NEW_APP_TYPE IN AssocArrayVarchar2_t,
V_END_DATE IN AssocArrayDate_t,
V_NEW_END_DATE IN AssocArrayDate_t,
V_FACILITY_TYPE_ID IN AssocArrayVarchar2_t,
V_NEW_FACILITY_TYPE_ID IN AssocArrayVarchar2_t,
V_ITEM_ID IN AssocArrayVarchar2_t,
V_NEW_ITEM_ID IN AssocArrayVarchar2_t,
V_START_DATE IN AssocArrayDate_t,
V_NEW_START_DATE IN AssocArrayDate_t,
V_CREATE_DTIME IN AssocArrayVarchar2_t,
V_CREATE_STAFF IN AssocArrayVarchar2_t,
V_DAYTIME IN AssocArrayVarchar2_t,
V_EVENING IN AssocArrayVarchar2_t,
V_MORNING IN AssocArrayVarchar2_t,
V_RETIRING IN AssocArrayVarchar2_t,
V_RISING IN AssocArrayVarchar2_t,
V_SEQ IN AssocArrayVarchar2_t,
V_SPECIFIED_TIME IN AssocArrayVarchar2_t,
V_UPDATE_DTIME IN AssocArrayVarchar2_t,
V_UPDATE_STAFF IN AssocArrayVarchar2_t,
V_ACTIONFLAG IN AssocArrayChar_t,
RegistrationType IN VARCHAR2,
ErrorInfo OUT CLOB,
SystemDate OUT DATE
) ;END;
请问里面的table是什么类型的啊??? 我调用存储过程的时候应该传入什么样的数据呢?
TYPE AssocArrayChar_t IS TABLE OF CHAR INDEX BY BINARY_INTEGER;
TYPE AssocArrayVarchar2_t IS TABLE OF VARCHAR2(1024) INDEX BY BINARY_INTEGER;
TYPE AssocArrayNVarchar2_t IS TABLE OF NVARCHAR2(60) INDEX BY BINARY_INTEGER;
TYPE CursorType IS REF CURSOR;
TYPE AssocArrayDate_t IS TABLE OF DATE INDEX BY BINARY_INTEGER;
PROCEDURE SET_APPCOMMENTMNGDATA(
V_APP_TYPE IN AssocArrayVarchar2_t,
V_NEW_APP_TYPE IN AssocArrayVarchar2_t,
V_END_DATE IN AssocArrayDate_t,
V_NEW_END_DATE IN AssocArrayDate_t,
V_FACILITY_TYPE_ID IN AssocArrayVarchar2_t,
V_NEW_FACILITY_TYPE_ID IN AssocArrayVarchar2_t,
V_ITEM_ID IN AssocArrayVarchar2_t,
V_NEW_ITEM_ID IN AssocArrayVarchar2_t,
V_START_DATE IN AssocArrayDate_t,
V_NEW_START_DATE IN AssocArrayDate_t,
V_CREATE_DTIME IN AssocArrayVarchar2_t,
V_CREATE_STAFF IN AssocArrayVarchar2_t,
V_DAYTIME IN AssocArrayVarchar2_t,
V_EVENING IN AssocArrayVarchar2_t,
V_MORNING IN AssocArrayVarchar2_t,
V_RETIRING IN AssocArrayVarchar2_t,
V_RISING IN AssocArrayVarchar2_t,
V_SEQ IN AssocArrayVarchar2_t,
V_SPECIFIED_TIME IN AssocArrayVarchar2_t,
V_UPDATE_DTIME IN AssocArrayVarchar2_t,
V_UPDATE_STAFF IN AssocArrayVarchar2_t,
V_ACTIONFLAG IN AssocArrayChar_t,
RegistrationType IN VARCHAR2,
ErrorInfo OUT CLOB,
SystemDate OUT DATE
) ;END;
请问里面的table是什么类型的啊??? 我调用存储过程的时候应该传入什么样的数据呢?
http://blog.csdn.net/zcywell/article/details/7258049