Re: TO_CHAR - differences v.8.1.7 vs. 9.2.0

On Mon, 5 Sep 2005 10:25:20 +0200, "Randi W" <randiwolner_at_hotmail.com> wrote:

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

Great solution. Reinventing the wheel and introducing more unstable code, in a solution that is already instable. Why don't you follow up Mark's suggestion and repair the generator, instead of introducing new hacks.
And, BTW, why do you insist on top-posting? Do you read from bottom to top, or is hitting ctrl-end asked too much?

--
Sybrand Bakker, Senior Oracle DBA