在网上查到了这样的
declare
I_NAME VARCHAR2(10) := 'xxx';
I_IS_USING VARCHAR2(2) := '1';
v_cursor SYS_REFCURSOR;
v_count NUMBER;
r_emp emp%rowtype; ?? 这里不理解
begin
PROC_T_PROCEDURE_OBJ_LIST(I_NAME,I_IS_USING, v_cursor,v_count);
loop
fetch v_cursor into r_emp;
exit when v_cursor%NOTFOUNRD;
dbms_output.put_line('name: ' || r_emp.NAME || ' info: ' || r_emp.INFO || ' using: ' || r_emp.IS_USING);
end loop;
close v_cursor;
end;