Re: Should TO_CHAR be replaced by high level code with pl/sql calls?

On 20 Nov 2003 13:18:02 -0800, edreyes77_at_hotmail.com (Ed) wrote:

>It has been suggested by an "Oracle Expert" that we replace all our
>TO_CHAR calls in our select statements into pre or post calls to high
>level functions such as C or C++. Can someone please comment as to
>whether this is worth the effort.
>
>Thanks In Advance,
>Ed Reyes

That's the daftest advice I have seen in ages. Why on earth would you switch to external function with the associated overhead to call them, when you have optimized native pl/sql functions?

--
Sybrand Bakker, Senior Oracle DBA