APEX

Hi

I am trying to upload a file and zip it before saving it to the table. I am using 3.2 and 11g. I know of UTL_COMPRESS but that's not the format I am looking for. I am looking for a .zip file . I also tried this solution (http://joelkallman.blogspot.com/2008/04/zip-it.html) but it is not working for me. when I run this process it takes a long time and finally is throwing a not responding error. I dont't know if it is the oracle 11g version that is causing this solution not to work. Please advice.

This is the code I am running based on the above java proc in the link

DECLARE
l_blob BLOB;
l_result INTEGER;
n_field NUMBER;
BEGIN
SELECT MAX (id)
INTO n_field
FROM apex_application_files
WHERE name = attachment_name;

l_result := ESCRMGR.ziplobs ('SELECT id, blob_content FROM apex_application_files'||
'WHERE id = n_feild',
l_blob);