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
