请问,那怎样返回许多行数据呢,象sqlserver里的 create procedure ysm as select * from dmk; 请给个例子
DECLARE tmp_sp PROCEDURE FOR sp_test(:par,...); 【其中过程sp_test返回一结果集】EXECUTE tmp_sp ;FETCH tmp_sp INTO :li_ret,...;CLOSE tmp_sp ;
CREATE OR REPLACE PACKAGE pkg_test AS TYPE myrctype IS REF CURSOR; END pkg_test; / create procedure ysm(p_rc out pkg_test.myrctype) as begin open p_rc for 'select * from dmk'; end ysm; /
这是在sql*plus里面输出
写一个带返回参数的就可以了
create procedure ysm
as
select * from dmk;
请给个例子
【其中过程sp_test返回一结果集】EXECUTE tmp_sp ;FETCH tmp_sp INTO :li_ret,...;CLOSE tmp_sp ;
AS
TYPE myrctype IS REF CURSOR;
END pkg_test;
/
create procedure ysm(p_rc out pkg_test.myrctype)
as
begin
open p_rc for 'select * from dmk';
end ysm;
/