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

    Hello,

    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

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Not without seeing the code for jzip.compress_file.