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 -> Ora-6502 Error in assigining value to varchar2 out param

Ora-6502 Error in assigining value to varchar2 out param

From: <debashish.majumdar_at_gmail.com>
Date: 27 Aug 2006 06:39:09 -0700
Message-ID: <1156685949.050784.138360@b28g2000cwb.googlegroups.com>


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

Original text of this message

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