创建:
CREATE OR REPLACE PROCEDURE UpdateState (
v_ID IN NUMBER DEFAULT 0, v_Result VARCHAR2 DEFAULT NULL, --退回的原因
v_Code VARCHAR DEFAULT NULL, --退回的用户编码
pRecCur IN OUT sys_refcursor ) AS BEGIN
--INSERT into ZWH_TEST values('123','123','123','123','123','123',SYSDATE);
open pRecCur FOR SELECT
'1' res,
'成功'
FROM
dual;
END;
调用:
Declare
Type Type_ROW is Record(
res varchar2(10),
res1 varchar2(15)
);
T_ROW Type_ROW;
type_cur sys_refcursor;
begin
UPDATESTATE(-1,'123','123',type_cur);
LOOP
FETCH type_cur INTO T_ROW;
EXIT WHEN type_cur%NOTFOUND;
DBMS_OUTPUT.PUT_LINE('code:'||T_ROW.res||' name:'||T_ROW.res1||'' );
END LOOP;
CLOSE type_cur;
end;
查询结果: