CREATE OR REPLACE PACKAGE pkg_test
AS
TYPE myrctype IS REF CURSOR;
END pkg_test;
/
create procedure get_talbe(p_table in varchar2,p_rc out pkg_test.myrctype)
as
str varchar2(50);
begin
str:='select * from '||p_table;
open p_rc for str;
end;
/
AS
TYPE myrctype IS REF CURSOR;
END pkg_test;
/
create procedure get_talbe(p_table in varchar2,p_rc out pkg_test.myrctype)
as
str varchar2(50);
begin
str:='select * from '||p_table;
open p_rc for str;
end;
/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货