17,382
社区成员




Create procedure getall
select * from table1.
create or replace procedure p_test(p_cur out sys_refcursor)
as
begin
open p_cur for select * from emp;
end p_test;
declare
test_cur SYSBASIC.cc_CURSOR;
bm SSFJ.BM%TYPE;
mc SSFJ.MC%TYPE;
begin
getfj(test_cur);
loop
fetch test_cur into bm,mc;
exit when test_cur%notfound;
dbms_output.put_line('编码:'||bm);
end loop;
end;