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

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

Fire the "Expert".

Then hire someone that knows what they are talking about. I can only wonder at the other "advice" your organization has received. I'd get a second opinion, from someone competent, before I followed any of it.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)