可以啊create or replace procedure mytest
(my_select in varchar2)
as
type ref_cursor is ref cursor;
my_cursor ref_cursor;
begin
open my_cursor for my_select;
loop
--
end loop;
close my_cursor;
end mytest;
/
(my_select in varchar2)
as
type ref_cursor is ref cursor;
my_cursor ref_cursor;
begin
open my_cursor for my_select;
loop
--
end loop;
close my_cursor;
end mytest;
/
f_ky的方法也行,建议8i以下版本使用。