Re: ora-06502 with PL/SQL

Monique,

6502 within PL/SQL usually refers to some more basic problem than selects in the SGA.

It's usually a problem (for me at least) of putting a value in a local varible that is too large for that value.

Check that all you VARCHAR2 variables are large enough .. and check that you don't do a divide by zero anywhere .. !

For instance if you are dividing anything by the number of rows in the table .. and the table is empty ..??

regards

pod

Monique van Daal wrote:

> 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 - 10:44:48 CST