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

From: buu <aha_at_a.com>
Date: Sat, 8 Mar 2008 23:45:58 +0100
Message-ID: <fqv4v4030bj@enews2.newsguy.com>


notice that exception handler in function does not recieve any errors...

"buu" <aha_at_a.com> wrote in message news: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.
>
>
Received on Sat Mar 08 2008 - 16:45:58 CST

Original text of this message