Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Ora-6502 Error in assigining value to varchar2 out param
hi,
I ve the following proc:
1 create or replace procedure checkit(a out varchar2) as
2 begin
3 a := 'Deb';
4* end;
When i execute this SP i am greeted by the following error:
SQL> exec checkit(:a1);
BEGIN checkit(:a1); END;
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number
conversion error
ORA-06512: at line 1
It wd be gr8 if anyone could help me in this. Sorry for asking such a basic question.
Thanks in advance
Deb
Received on Sun Aug 27 2006 - 08:39:09 CDT
![]() |
![]() |