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

<debashish.majumdar_at_gmail.com> wrote in message news:1156694064.335058.291960_at_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/
>

Eeeh, passing on an input parm to a procedure having only an output parm ? Received on Sun Aug 27 2006 - 11:32:46 CDT