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

From: William Robertson <>
Date: Sun, 9 Mar 2008 03:03:22 -0700 (PDT)
Message-ID: <>

On Mar 8, 11:22 pm, "buu" <> 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