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.