代码:CREATE OR REPLACE PROCEDURE P_TESTB AS VARCURSOR SYS_REFCURSOR;R USERS%ROWTYPE;BEGIN P_TESTA(VARCURSOR);LOOP FETCH VARCURSOR INTO R;EXIT WHEN VARCURSOR%NOTFOUND;DBMS_O...
返回一个游标社！有俩种方法:一种是声明系统游标,一种是声明自定义游标,然后后面操作一样,参数类型为 in out 或out (1)声明个人系统游标.(推荐)create or replace p_temp_procedure (cur_arg out sys_refcursor; --方法1 )begin open cur_arg f...
