"ORA-06502: PL/SQL: numeric or value error: number precision too large"
559321Jan 15 2008 — edited Jan 16 2008Hi,
I am facing a very strange issue, perhaps a data issue.
My PL/SQL Script extracts data from GL tables, load it into temporary tables, spool into flat files and FTP those files.
I tested the program for 5 records,worked fine.
But when I run the program for all records, I got the below error:
"ORA-06502: PL/SQL: numeric or value error: number precision too large"
1. None of the data exceed the limit of (14,4).
2. None of the data is NULL
How can I resolve this ? This is URGENT, please help.
Thanks !
Yogini