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

On Mar 8, 4:45 pm, "buu" <a..._at_a.com> wrote:
> notice that exception handler in function does not recieve any errors...
>
>
>
> "buu" <a..._at_a.com> wrote in messagenews:fqv4os02vti_at_enews2.newsguy.com...
> >I have an procedure with an query like:
>
> > function aa() return varchar2 as
>
> > begin
> > update table1
> >   set field_1='xxx'
> >  where id=1
> > returning field_2 into v_retval:
>
> > return v_retval;
> > end;
>
> > I'm handling that simple function in vb.net 2005.
> > But, in vb.net I receive an ORA 6502 error.. why? fileld size is not a
> > problem.- Hide quoted text -
>
> - Show quoted text -

WHAT exception handler??? I see none coded in that function.

And what is the full error message text you receive, which release of Oracle are you using (all four numbers) and HOW are you using this bizarre function?

David Fitzjarrell Received on Sat Mar 08 2008 - 17:16:25 CST