CREATE OR REPLACE TYPE IM_CHECKLIST_PARAM IS OBJECT(
ID RAW(16),
SCORE INTEGER,
DESCRIPTION NVARCHAR2(300),
FOLLOWPLAN NVARCHAR2(300)
);
CREATE OR REPLACE TYPE IM_CHECKLIST_TABLE_PARAM AS TABLE OF IM_CHECKLIST_PARAM;
包中IN_TableParam在C#怎么传递
CREATE OR REPLACE PACKAGE PKG_IM_CHECKLIST AUTHID CURRENT_USER AS
TYPE T_CURSOR IS REF CURSOR;
PROCEDURE UpdateAMChecklist(IN_Hid IN VARCHAR2,
IN_Status IN INTEGER,
IN_Employee_No IN varchar2,
IN_Employee_Name IN varchar2,
IN_TableParam IN IM_CHECKLIST_TABLE_PARAM,
IO_CURSOR OUT T_CURSOR);
END PKG_IM_CHECKLIST;
PROCEDURE UpdateAMChecklist(IN_Hid IN VARCHAR2,
IN_Status IN INTEGER,
IN_Employee_No IN varchar2,
IN_Employee_Name IN varchar2,
IN_TableParam IN IM_CHECKLIST_TABLE_PARAM,
IO_CURSOR OUT T_CURSOR) IS
V_ErrorMsg varchar2(1000);
V_CURSOR T_CURSOR;
BEGIN
BEGIN
V_ErrorMsg := '0';
-----......
COMMIT;
EXCEPTION
WHEN OTHERS THEN
V_ErrorMsg := SUBSTR(SQLERRM, 1, 200);
ROLLBACK;
END;
OPEN V_CURSOR FOR
SELECT V_ErrorMsg Msg from dual;
IO_CURSOR := V_CURSOR;
END UpdateAMChecklist;

置顶，谢谢各位大哥帮忙