Ok, we just got a new idea about this, which is to write our own
"TO_CHAR"-function and overload it with the datatypes that are likely to
come as parameters. In the one with at VARCHAR2-parameter we just return the
same value that was sent in, but in the others we return the result from
TO_CHAR.
"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message
news:1125848320.873884.153060_at_g43g2000cwa.googlegroups.com...
>I see this as a code generator design issue. I think that the trigger
> generator needs to have some datatype match logic added to it so that
> it only adds a to_char or a to_number where the two datatypes in an
> assignment do not match. That or code generator needs to be version
> aware.
>
> IMHO -- Mark D Powell --
>
Received on Mon Sep 05 2005 - 03:25:20 CDT
