create or replace procedure lu(out outList) asbegin select * from scott.s;end;
通过游标实现 CREATE OR REPLACE PROCEDURE(result OUT t_cursor ) test AS TYPE t_cursor REF CURSOR; BEGIN OPEN result FOR SELECT * FROM scott.s; EXECEPTION WHEN OTHERS THEN NULL; END;
select * from scott.s;end;
CREATE OR REPLACE PROCEDURE(result OUT t_cursor ) test AS
TYPE t_cursor REF CURSOR;
BEGIN
OPEN result FOR SELECT * FROM scott.s;
EXECEPTION
WHEN OTHERS THEN NULL;
END;