Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ORA-06502: PL/SQL Error: numeric or value error

ORA-06502: PL/SQL Error: numeric or value error

From: nodge <nodge.trottier_at_googlemail.com>
Date: 30 May 2007 02:53:59 -0700
Message-ID: <1180518839.633753.38940@w5g2000hsg.googlegroups.com>


I've got an PL/SQL Error:

 SQL> declare
   2 v_tmp char(15);
   3 BEGIN
   4 v_tmp := '';
   5 v_tmp := v_tmp || 'thw';
   6 insert into thwtab values (42, v_tmp);    7 commit;
   8 end;
   9 /
 declare
 *
 ERROR at line 1:
 ORA-06502: PL/SQL: numeric or value error  ORA-06512: at line 5

Any Suggestions? Whats wrong?

thx!
nodge Received on Wed May 30 2007 - 04:53:59 CDT

Original text of this message

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