title: Zip using Oracle Stored Procedure
body: <p>Right now I am using Oracle utility procedure, <code>UTL_COMPRESS.LZ_COMPRESS()</code>, to compress some data. But the problem is it compresses the thing using GZIP compatible format, which is not also ZIP compatible unfortunately. Therefore, the Windows XP native decompression utility can not open it (you know that compressed folder thingie). And user have to use some other utility, like <code>7Zip</code>, <code>Winzip</code>, or <code>Filzip</code> etc., in order to decompress that.</p>
  
  <p>So, we end up having a plan of retrieving GZIP data from Oracle, uncompress it using Java, and compress it back to ZIP (something that can be decompressed by Windows utility). It sounds ridiculous to <code>compress-in-gzip -&gt; decompress -&gt; compress-again-in-zip</code>.</p>
  
  <p><strong>Any idea how can we compress it in the desirable format in the first place, to avoid all this extra computation?</strong></p>