- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
create or replace procedure rout_cancel (
p_sql varchar2
) is
v_curs sys_refcursor;
begin
if v_curs%isopen then
close v_curs;
end if;
begin
open v_curs for p_sql;
exception
when others then
raise_application_error(-20000, 'Unable to open cursor');
end;
rout_cancel_details(v_curs);
close v_curs;
end;
guest 25.06.2011 02:01 # −2
dwinner 27.06.2011 12:06 # +2
guest8 09.04.2019 10:57 # −999