Re: ORA-06502 error when returning varchar2...

From: William Robertson <williamr2019_at_googlemail.com>
Date: Sun, 9 Mar 2008 03:03:22 -0700 (PDT)
Message-ID: <484198fa-d11a-4a1f-8481-f3edfce90490@60g2000hsy.googlegroups.com>


On Mar 8, 11:22 pm, "buu" <a..._at_a.com> wrote:
> this is only a core part of function and there is exception (when others) in
> int...

"WHEN OTHERS" rings alarm bells, especially when
> notice that exception handler in function does not recieve any errors...

What's the rest of the exception handler?

Often a quick way to improve code is to remove the entire exception section. Received on Sun Mar 09 2008 - 05:03:22 CDT

Original text of this message