1.存储过程如下:CREATE OR REPLACE PROCEDURE DEMO(V_V_ROLECODE VARCHAR2,
V_INFO OUT VARCHAR2, --执行信息,成功'success'
V_CURSOR OUT SYS_REFCURSOR) IS
BEGIN
OPEN V_CURSOR FOR
SELECT * FROM BASE_ROLE T WHERE T.V_ORLECODE = V_V_ROLECODE;
V_INFO := 'success';
EXCEPTION
WHEN OTHERS THEN
V_INFO := SQLERRM;
END DEMO;