Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ora-06502 with PL/SQL
You normally get this error when you try and put a string in a variable
which isn't long enough to cope wih it
In this example, a variable is defined as varchar2(10) but the string being allocated to it is 22 characters.
SQL> declare
2
2 v_string varchar2(10);
3
3 begin
4
4 v_string := 'The Cat Sat OnThe Mat';
5
5 end;
6 /
declare
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 4
Check your data and variable length definitions.
Mark
Monique van Daal wrote in message <36fb9a18.22395132_at_news.atriserv.nl>...
>We are doing an Y2k test with Oracle 7.3 on SunSolaris.
>We have a lot of loads and PL/SQL's which are processed after each
>other.
>This test is documented. Then we , truncate the tables.
>After that exactly the SAME PROCEDURE is started with loads en
>PL/SQL's.
>This second time we got the ora-06502 error.
>When we stopped the database between the two times, there was no
>problem.
>I alsi tried to flush the sqlarea, this has the same effect as
>stopping the database.
>I think it has something to do with the select-statements in the
>sqlarea.
>Is there anybody who can tell me more about this?
>
>ora 06502 PL/SQL: numeric or value error
Received on Fri Mar 26 1999 - 09:52:09 CST