oracle 转化数字异常,数字或错误:字符到数值的转换错误

请问这个存储过程什么地方写错了`???在测试时,报PL/SQL:数字或错误:字符到数值的转换错误,在CISDEV.SENSITIVEPHONE,LINE13 在LINE3

create or replace procedure Sensitivephone

(managerunitid In out number,

Mincode in out varchar2,

Maxcode In out varchar2,

Contactofficephone  In out varchar2,

sensitiveexplain  In out varchar2,

displayvalue In out varchar,

operatorname in out varchar2,

cur_result_out Out sys_refcursor) as

str_sql Varchar2(200);

Begin

If managerunitid is Not Null Then

managerunitid:='and a.managerunitid=' ;

ElsIf Mincode is Not Null Then

Mincode := 'and  a.customercode between ';

ElsIf Maxcode is Not Null Then

Maxcode := 'and  ';

ElsIf Contactofficephone is Not Null Then

Contactofficephone := 'and  a.Contactofficephone=';

ElsIf sensitiveexplain is Not Null Then

sensitiveexplain := 'and  a.sensitiveexplain=';

ElsIf displayvalue is not null then

displayvalue:='and syssen.displayvalue=';

elsif operatorname is not null then

operatorname :='and d2.operatorname=';

str_sql  := 'select

ROW_NUMBER() over (order by a.customerid) as rid,a.customercode,a.Contactofficephone

,a.SensitiveExplain,syssen.displayvalue,d2.operatorname,a.ModifyDate,d1.operatorname,a.InputDate

from  t_mc_customer a

left join  t_mc_customermodifyrecord b on b.customerid=a.customerid

left join t_sec_manageunit c on c.unitcode=a.managerunitid

inner join T_SEC_OPERATOR d1 on d1.operatorid=a.inputoperatorid

left join T_SEC_OPERATOR d2 on d2.operatorid=a.ModifiedByID

left join (select * from s_msa_syscode where paracode=''SensitiveType'') syssen on syssen.storevalue=a.SensitiveTypeID

where 1=1 ' ||managerunitid||