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

From: buu <aha_at_a.com>
Date: Sun, 9 Mar 2008 00:22:27 +0100
Message-ID: <fqv73g0vaf@enews4.newsguy.com>


this is only a core part of function and there is exception (when others) in int...
oracle is XE 10.2.0.1.0

what I did noticed now is when I put an any kind of hard-coded string as an return value, there is an error..
is there possibility that vb.net 2005 (using Oracle.DataAccess.Client.OracleCommand object) does not support varchars as an return value?

<fitzjarrell_at_cox.net> wrote in message
news:a64a3ba6-e06b-44f6-8bf9-a1de31ed8c54_at_n58g2000hsf.googlegroups.com... 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:22:27 CST

Original text of this message