Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Ora-6502 Error in assigining value to varchar2 out param

Re: Ora-6502 Error in assigining value to varchar2 out param

From: <debashish.majumdar_at_gmail.com>
Date: 27 Aug 2006 08:54:24 -0700
Message-ID: <1156694064.335058.291960@i42g2000cwa.googlegroups.com>


oops. I was a little careless. Thanks a lot for replying.

Rene Nyffenegger wrote:
> On 2006-08-27, debashish.majumdar_at_gmail.com <debashish.majumdar_at_gmail.com> wrote:
> > Hi,
> > This Sp is modified a little. The same problem is still there.
> >
> > 1 create or replace procedure checkit(a out varchar2) as
> > 2 begin
> > 3 a := 'Deb';
> > 4* end;
> > SQL> var b varchar2
> > SQL> exec checkit(:b);
> > BEGIN checkit(:b); END;
> >
> > *
> > ERROR at line 1:
> > ORA-06502: PL/SQL: numeric or value error: character string buffer too
> > small
> > ORA-06512: at "XXKMA_PPS_30.CHECKIT", line 3
> > ORA-06512: at line 1
>
>
> No, it's not the SAME problem, now you have 'character string buffer
> too small', yet, you had 'character to number conversion error':
>
>
> >
> >> > ERROR at line 1:
> >> > ORA-06502: PL/SQL: numeric or value error: character to number
> >> > conversion error
> >> > ORA-06512: at line 1
>
>
> When I declared the bind variable, I made it
> varchar2(10), you forgot the (10):
> >>
> >> RENE> variable f varchar2(10)
> >> RENE> exec checkit(:f)
> >>
> >> PL/SQL procedure successfully completed.
> >>
> >> RENE> print f
> >>
> >> F
> >> ------------------------------------------------
> >> Deb
>
>
> hth,
> Rene
>
> --
> Rene Nyffenegger
> http://www.adp-gmbh.ch/
Received on Sun Aug 27 2006 - 10:54:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US