junwen的博客

--/create or replace procedure pro_data(data out SYS_REFCURSOR) is begin open data for select id from scott.travelrecord;end pro_data; /alter procedure pro_data compile;--/ ...

--/create or replace procedure pro_2(id varchar2,id2 out varchar2)is name varchar2(20); -- begin id2 := 'result:' || id; dbms_output.put_line('id:' || id || ' name:' || name);end;...

前提scott有travelrecord表--/create or replace procedure pro_data(data out SYS_REFCURSOR) is begin open data for select id from scott.travelrecord;end pro_data; /alter procedure pro_data comp...

--/create or replace procedure pro_2(id varchar2,id2 out varchar2)is name varchar2(20); -- begin id2 := 'result:' || id; dbms_output.put_line('id:' || id || ' name:' || name);end;/...