apex_zip.add_file failed zipping 6.7 GB file
in Database
We have plsql program using apex_zip.add_file utility to zip CSV file. It is working fine in production where the single CSV file size in 3.5 GB around. But it failed in DEV Database where we get a file of 6.7GB size. File is read from object storage.
Below is the error we are getting in DEV Database
Error report -
ORA-01426: numeric overflow
ORA-06512: at "APEX_230200.WWV_FLOW_ZIP", line 525
ORA-06512: at line 8
01426. 00000 - "numeric overflow"
*Cause: Evaluation of an value expression causes an overflow/underflow.
*Action: Reduce the operands.
ERROR
-----------------------
ORA-01426
Note -
DEV is 2 core CPU
Tagged:
0