TO_CHAR - differences v.8.1.7 vs. 9.2.0

From: Randi W <randiwolner_at_hotmail.com>
Date: Sun, 4 Sep 2005 11:11:10 +0200
Message-ID: <dfedne$q5i$1@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. Received on Sun Sep 04 2005 - 04:11:10 CDT