例
CREATE OR REPLACE PACKAGE pkg_test
AS
TYPE myrctype IS REF CURSOR;
END pkg_test;
/
CREATE PROCEDURE sp_fauleinfo(pAgentID in varchar2,p_rc out pkg_test.myrctype)
AS
begin
open p_rc for 'Select Agent_id,Agent_name from failinfo where AgentID='||pAgentID;
end;
CREATE OR REPLACE PACKAGE pkg_test
AS
TYPE myrctype IS REF CURSOR;
END pkg_test;
/
CREATE PROCEDURE sp_fauleinfo(pAgentID in varchar2,p_rc out pkg_test.myrctype)
AS
begin
open p_rc for 'Select Agent_id,Agent_name from failinfo where AgentID='||pAgentID;
end;
解决方案 »
- oracle中clob字段处理
- 关于3张表的查询
- 向[inthirties]提問,關於表空間壓縮.
- 动态SQL取tablename%rowtype类型的数据问题?急求高手指导
- 请教关于一个联合查询时出现的问题!!!
- 谁帮我修改下这个存储过程~
- 这个问题这么解决?ORA-02270: no matching unique or primary key for this column-list
- ┣┫游标提取循环的高级问题(高分)?
- 如何计算两个日期间隔的月数?
- 求一个oracl触发器
- 请问SQL,PL/SQL,SQL*Plus,PL/SQL Developer之间的关系是什么?
- [急]PL/SQL写查询条件
create or replace package scott.ljyPac is
type ljyType is ref cursor;
procedure ljy1( x OUT scott.ljyPac.ljyType );
end ljyPac;create or replace procedure scott.ljy1( x out SCOTT.LJYPAC.ljyType ) is
begin
open x for select * from scott.emp;
end ljy1;
AS
TYPE myrctype IS REF CURSOR;
END aa;
/
create procedure a(p_cur out aa.myrctype)
as
str varchar2(200);
begin
str:='select * from SCOTT.EMP';
open p_cur for str;
end;
/
你找到那个控键,:应该是(TStoredProc)看下帮助
“Operation not applicable""
select * from fun_name(); 不就可以了吗?
http://expert.csdn.net/Expert/topic/1999/1999981.xml?temp=.9277002