日期:2014-05-17  浏览次数:20656 次

求各位大神帮帮小弟 帮帮小弟
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(





------解决方案--------------------
这次应该比较清楚为什么你有错的了吧