1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

jzip oracle package

Discussion in 'SQL PL/SQL' started by joru187, Oct 15, 2010.

  1. joru187

    joru187 Guest


    My no oracle expert but I just wondered if someone can help.

    We have upgraded our oracle database to 11g and we used to be able to run the following via sql.

    If we run the following on current Oracle installation it appears to complete but we do not get the resulting zip file:
    SQL> Exec jzip.compress_file('/home/oracle/stibo/output/Attr_Info_US.txt','/home/oracle/stibo/output/Attr_Info_US.zip');
    PL/SQL procedure successfully completed.

    Does anyone know what might be the cause of this please?

    Cheers Joe.
  2. zargon

    zargon Community Moderator Forum Guru

    Likes Received:
    Trophy Points:
    Aurora, CO
    Not without seeing the code for jzip.compress_file.