是动态的 可是我想把他放入游标中 open v_Cursor for execute immediate str; 为什么不可以?
CREATE OR REPLACE PACKAGE pkg_test AS TYPE myrctype IS REF CURSOR; END pkg_test; / create procedure pro(p_sql in varchar2,p_rc out pkg_test.myrctype) as begin open p_rc for p_sql; end; /
open v_Cursor for
execute immediate str;
为什么不可以?
AS
TYPE myrctype IS REF CURSOR;
END pkg_test;
/
create procedure pro(p_sql in varchar2,p_rc out pkg_test.myrctype)
as
begin
open p_rc for p_sql;
end;
/