Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    2

    Question Unanswered: zip a unix file via pl/sql

    I produce large text files from pl/sql packages on Oracle 8i, using utl_file. I would like to zip these files after producing them, in the same pl/sql procedure.
    How can I do it?

  2. #2
    Join Date
    Sep 2003
    Posts
    156

    Re: zip a unix file via pl/sql

    Originally posted by aderette
    I produce large text files from pl/sql packages on Oracle 8i, using utl_file. I would like to zip these files after producing them, in the same pl/sql procedure.
    How can I do it?
    are you using *nix - you can create a tar.z file. Alternatively the java utility jar and unjar can be used for the above purpose but the compression would not be of great extent.

    If using windows, i guess you can use something like my vbscript ROLF (Removal Of Log Files) a .vbs that runs as a scheduled .bat file, you could write one to dump daily files to a .zip archive.
    Last edited by GhostMan; 02-17-04 at 09:54.
    rgs,

    Ghostman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •