Programer Life/DB
REF CURSOR 호출 방법
신비마마
2011. 3. 24. 17:49
Declare
out_code varchar2(11);
out_msg varchar2(100);
type ref_cur is ref cursor;
r_cur ref_cur;
begin
r_cur := PackageName.FunctionName(Parameters...);
dbms_output.put_line(out_code);
dbms_output.put_line(out_msg);
end;
/
out_code varchar2(11);
out_msg varchar2(100);
type ref_cur is ref cursor;
r_cur ref_cur;
begin
r_cur := PackageName.FunctionName(Parameters...);
dbms_output.put_line(out_code);
dbms_output.put_line(out_msg);
end;
/