6502ORA-06502: PL/SQL: numeric or value error
Hi,
I have a PL/SQL package which has been running from 6 months.
2-3 times the package recorded "6502ORA-06502: PL/SQL: numeric or value error" without any extension of SQLERRM as "character string buffer too small", etc.
There are only two reasons for Oracle server to raise exactly that SQLERRM I think.
1. trying to assign NULL for NOT NULL declared variable.
2. trying to assign NULL for declared variable which inherit NOT NULL constraint by %TYPE.
None of the above is the reason.
I am using Bulk SQL, Collections, etc. features of PL/SQL in the package.
Could somebody point to another situation for Oracle to raise that error message "6502ORA-06502: PL/SQL: numeric or value error", but without any additional information?
Konstantin