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 - 08:43:59 CST
