请大侠帮助小弟如何在pl/sql程序中调用?
delfa 2004-04-20 09:36:30 创建了如下的存储过程包体返回结果集
CREATE OR REPLACE PACKAGE PAC_Mycursor
AS
TYPE QUERY_CURSOR IS REF CURSOR;
PROCEDURE My_cur_out(
p_nsrsbh IN varchar2,
p_nd in varchar2,
p_yf in varchar2,
p_table in varchar2,
result1 out QUERY_CURSOR);
END PAC_Mycursor;
--------------------------------------------------------------------------
CREATE OR REPLACE PACKAGE BODY PAC_Mycursor
AS
PROCEDURE My_cur_out(
p_nsrsbh IN varchar2,
p_nd in varchar2,
p_yf in varchar2,
p_table in varchar2,
result1 out QUERY_CURSOR
)
AS
sqlstr VARCHAR2(1000);
BEGIN
sqlstr:='select t.*,t.sbrq,t.tbrq '|| p_table||'t where nsrsbh='''|| p_nsrsbh||''''||' and nd='|| p_nd ||' and yf='|| p_yf;
--DBMS_OUTPUT.PUT_LINE(sqlstr);
OPEN result1 FOR sqlstr;
--SELECT * from sb_zzs_ybns; --where area_id = An_area_id and serv_id > An_serv_id ;
--execute sql sqlstr;
--EXECUTE IMMEDIATE sqlstr;
END;
END PAC_Mycursor;
---------------------------------------------------------------------
请问如何在pl/sql中调用执行(如以上代码没有问题的话)?
请各位大侠不吝赐教,小弟不胜感激!(如嫌分数不够,可另外开贴追加)