存储过程有点问题请大神帮忙看看

[minzhouzhang]

create or replace procedure proc_CLXX_List --查询

(

pro_cursor out pkg_order.p_cursor, --查询结果集

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 end proc_client_List';

[人生无悔]

create or replace procedure proc_CLXX_List(
pro_cursor out pkg_order.p_cursor,
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;
/

[软件钢琴师]

execute immediate sql_str;

[mo_ying]

'PKG_ORDER.P_CURSOR'中PKG_ORDER这个包里没有定义p_cursor吧。

[minzhouzhang]

pro_cursor out pkg_order.p_cursor,


PROCEDURE GL63.PROC_CLXX_LIST 编译错误

错误：PLS-00201: 必须说明标识符 'PKG_ORDER.P_CURSOR'
行：2
文本：pro_cursor out pkg_order.p_cursor,

错误：PL/SQL: Compilation unit analysis terminated
行：1
文本：create or replace procedure proc_CLXX_List(