procedure ExecDDL(productsinfo out ODPNet.refcur) is
str_sql varchar2(500);
begin
str_sql :=
'
select * from products
';
execute immediate str_sql;
exception
when others then
null;end ExecDDL;希望将select 的结果通过游标productsinfo 返回,请问如何写~~~~
str_sql varchar2(500);
begin
str_sql :=
'
select * from products
';
execute immediate str_sql;
exception
when others then
null;end ExecDDL;希望将select 的结果通过游标productsinfo 返回,请问如何写~~~~
open productsinfo for str_sql;