I am using as_zip package by Anton Scheffer http://technology.amis.nl/wp-content/uploads/images/as_zip.txt
When trying to zip a 2+ GB file I get the following error
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.UTL_RAW", line 380
ORA-06512: at "SANJEEV.AS_ZIP", line 321
ORA-06512: at "SANJEEV.AS_ZIP", line 356
ORA-06512: at line 4
06502. 00000 - "PL/SQL: numeric or value error%s"
*Cause:
*Action:
The error is being raised by the little_endian function.
function little_endian(
p_big in number
, p_bytes in pls_integer := 4
)
return raw
is
begin
return utl_raw.substr
( utl_raw.cast_from_binary_integer( p_big
, utl_raw.little_endian
)
, 1
, p_bytes
);
end;
The function uses utl_raw.cast_from_binary_integer. I tried using utl_raw.cast_from_number but did not create the correct zip file. Has anyone found a fix for this error? The package works great for smaller files--a big thanks to Anton.