You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

apex_zip.add_file failed zipping 6.7 GB file

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!