create or replace procedure proc_CLXX_List(
pro_cursor out sys_refcursor,
pzh_ in varchar2,
beginTime_ in date,
endTime_ in date
)
is
sql_str varchar2(1000):= 'select * from o_hbbz_djb a where(:pzh_ is null or a.PZH like :pzh_)
and (:beginTime_ is null or a.FFTIME > :beginTime_)
and (:endTime_ is null or a.FFTIME < :endTime_)
and rownum<=500';
begin
open pro_cursor for sql_str
using pzh_,pzh_,beginTime_,beginTime_,endTime_,endTime_;
end;-----------------------------------------
PROCEDURE GL63.PROC_CLXX_LIST 编译错误错误:PLS-00201: 必须说明标识符 'SYS_REFCURSOR'
行:2
文本:pro_cursor out sys_refcursor,错误:PL/SQL: Compilation unit analysis terminated
行:1
文本:create or replace procedure proc_CLXX_List(
pro_cursor out sys_refcursor,
pzh_ in varchar2,
beginTime_ in date,
endTime_ in date
)
is
sql_str varchar2(1000):= 'select * from o_hbbz_djb a where(:pzh_ is null or a.PZH like :pzh_)
and (:beginTime_ is null or a.FFTIME > :beginTime_)
and (:endTime_ is null or a.FFTIME < :endTime_)
and rownum<=500';
begin
open pro_cursor for sql_str
using pzh_,pzh_,beginTime_,beginTime_,endTime_,endTime_;
end;-----------------------------------------
PROCEDURE GL63.PROC_CLXX_LIST 编译错误错误:PLS-00201: 必须说明标识符 'SYS_REFCURSOR'
行:2
文本:pro_cursor out sys_refcursor,错误:PL/SQL: Compilation unit analysis terminated
行:1
文本:create or replace procedure proc_CLXX_List(
http://topic.csdn.net/u/20090108/14/5af083af-2abc-4c19-a6aa-38caa170a714.html
这个错是说没有SYS_REFCURSOR 这个类型;
http://www.cnblogs.com/attraction/archive/2008/01/23/13489.html
http://www.chinaitpower.com/A200507/2005-07-27/171528.html
楼主去看看,就应该没问题了,创建包的时候,包头,包体分开创建