Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> ORA-06502: PL/SQL Error: numeric or value error
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
![]() |
![]() |