Re: TO_CHAR - differences v.8.1.7 vs. 9.2.0

"Randi W" <randiwolner_at_hotmail.com> wrote in message news:dfedne$q5i$1_at_services.kq.no...
>I have some auto-generated trigger code that works just fine in Oracle
>v.9.2.0, but in another database that is v.8.1.7 this line will not compile
>if both v1 and v2 are of type VARCHAR2:
>
> v1:=TO_CHAR(v2);
>
> Here it returns this error message:
> PLS-00307: too many declarations of 'TO_CHAR' match this call
>
> If the triggers were programmed 'by hand' one would obviously not try to
> convert a string variable to a string, but as the same code is generated
> for many different variables and some are numbers, the v.9.2.0-behavior is
> very convenient..
>
> Can someone confirm that there are differences in TO_CHAR between these
> versions, and is there any 'work-around' that could be used when
> generating the code, so that the same code could be used in both
> environments?
>
> Thanks,
> Randi W.
>

post the full trigger code Received on Sun Sep 04 2005 - 08:38:50 CDT