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;
/