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

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/