Re: TO_CHAR - differences v.8.1.7 vs. 9.2.0

Użytkownik Randi W napisał:

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

Why don't You change it to v1 := v2, since TO_CHAR function returns error when parameter is VARCHAR2 type, with desuported 8.1.7 database ?

-- 
Noel