2008/6/10 Martin Evans <[EMAIL PROTECTED]>:
> I believe this is the right error for what you have done because the only
> way for oracle to know which function you meant is if the bound parameters
> match the right function. Since you are binding dates as varchars and oracle
> can convert varchars to various types how can it know which function you
> meant?

Error occurs even when I define type for bind_param explicitly, e.g.:

 $sth->bind_param(':i_param2',  $sDateStart, { ora_type => ORA_VARCHAR2 });
 $sth->bind_param(':i_param3',  $sDateEnd,  { ora_type => ORA_VARCHAR2 });


> If it isn't that, then it may depend on what is bound for the
> date/varchar parameters e.g., if they are NULL then Oracle won't know which
> function you meant

They are always not NULLs in my case.

-- 
 WBR, Eugene Krivdyuk

Reply via email to