Re: utl_compress zip file
From: <hegyvari_at_ardents.hu>
Date: Fri, 17 Apr 2009 02:02:29 -0700 (PDT)
Message-ID: <91f4eec6-a908-43a4-ad28-302cb826c3e9_at_l1g2000yqk.googlegroups.com>
On ápr. 17, 09:29, Shakespeare <what..._at_xs4all.nl> wrote:
> pianokruk schreef:
>
>
>
> > Hello,
>
> > The following piece of code produces an ora-29294. If I save the
> > contents of the variable uj after the base64 decode to a file, the
> > file is a perfectly valid zip that can be unzipped. What am I missing?
>
> > declare
> > eredeti varchar2(6000) default
> > 'UEsDBBQAAgAIAOZIhzpMHviiHAQAABALAAAjABEAYTE0MjY5MjM3dDAwMTIwMDkw
> > NDA2MDAwMDAwMDE4OC54bWxVVA0AB+cX20nnF9tJ5xfbSb1WPY/jNhDtA+Q/EOr1
> > 7bPXC63ukAR3ua8UuVwQpONKtExbEg2S8q71D1KmT+MyxVXXpRXyvzKkRIlaL26L
> > A+LC8AzfjN6b4YycPL+vSnQkXFBW3zihFziI1BnLaV3cOB9/eeleOc/TRKFcIU8l
> > EVtCJJKnA7lxJLmX/r0oHbTlZHPj4HARLddRvJJBELphoD6hu2EeYKSDKpJTfOMc
> > 8g2k/Pabr0k6z7iVVdmnFC2uSowgcS2UXx6uff/u7s4jByakt2180kOcHnN9L+gM
> > dxd7jBd+BM/wf3v/7kO2JRV2aS0krjMCUYJeC+18xzIsddG+8Bj0CHtFPneALUKJ
> > xuMcS22C4xa3VOCW1UxQydJZOJBaB4tgGfSf8Ooq8R/ghyz7psyZS/N5fOKP/hkO
> > xNAyLQjH3g5Dohc1PZJGgAwT0SMMRbJhBZ7i8C3jEMgxfaG/ddwDkBbrz9UmGSls
> > 6RUpanIkLRFp9wc/dn/XJ0lKUnef5L9/ItF2Zyho4luwIbApThtS7lmeRqBxsoZj
> > IRmvTWlGu2VSuoJx1adHyxwPZQ6WS4+IOPEfiRtzAqkdKU6K1ECUs1p2Z6H5mqOB
> > kG8xSny7CsmG7EqSGSApoYLTQ0B2+pNuDfqe1aIpJQwpesVZc0BvN9JLfIUY4RCr
> > SRptbuQuosQ37hGX0ckAU0sr0ve4OIEIruQUiT94LZzqzaGB2U2/a3J8IEIm/uSz
> > gLSvVRio+0rnhVN3kLWScMX85+687z5nLYVrNzovkDtSlmn3jzQgbVuoLW77560T
> > 3/wetfq2WBi2et/P6cBwFQTxGsq0ehbCNVi6z8K1njQ1ZzOo6aTdoeRIjg+69QP3
> > 0JvuDEOBXnVnmBPU/VWc4GrnFL3mLMcPWva/tSKOvtyKX7tzeWLF041oZIaf6sTq
> > shHqclfAUKavoYj9L+sM72CXPYO7upPs0eYlvlXsYevTemNPOTNa+2UZAYuLsd1T
> > XJYwfE2Vqql3g4UbLEHO5B6hUM+djYzdONRV3j0Abmi7xRJzChfDJA0hqe23wRVs
> > qu4sG4lLvS8G1yREi5P00Aic9psDlNjOEXogdVuTKv3x48vEN8a4dOZFggdNuwbU
> > qfuyN2BtIprDHwLHLgGvyF7dBclx3eJ9RpkbIli4R5LfcrYnHHY/Gg+7zwLl3aed
> > KpOJnGaPmG58+P0NWkVeHHhR7AXq1fHIeq3rEyxRkea3aqMaaw5I3Xg4tKdQSqaw
> > sGV5Gq0DNXG2a44Eh3u1MiD7GG8wvAszAT2Fe2kM+5hwCRV0w9VCA3pz0subIX8Y
> > LAAx2qY/uuZDa+x2JEwIeHlQOb1AIDtnRywvOvQEyaclfqUGQ2zaiIVmX1xwUO45
> > D+254NLjZnzmQMNhAM54WUi1MGwusEbtsprxSP8DUEsBAhcLFAACAAgA5kiHOkwe
> > +KIcBAAAEAsAACMACQAAAAAAAAAAAACAAAAAAGExNDI2OTIzN3QwMDEyMDA5MDQw
> > NjAwMDAwMDAxODgueG1sVVQFAAfnF9tJUEsFBgAAAAABAAEAWgAAAG4EAAAAAA==';
> > uj raw(30000);
> > kicsom raw(30000);
> > begin
> > uj := UTL_ENCODE.BASE64_DECODE(utl_raw.cast_to_raw(eredeti));
> > kicsom:=UTL_COMPRESS.LZ_UNCOMPRESS(uj);
> > end;
> > /
>
> > K
>
> Save to a file and load in a variable again and check the differences.
> My bet: missing an end-of-file character after decoding.
>
> Shakespeare
Date: Fri, 17 Apr 2009 02:02:29 -0700 (PDT)
Message-ID: <91f4eec6-a908-43a4-ad28-302cb826c3e9_at_l1g2000yqk.googlegroups.com>
On ápr. 17, 09:29, Shakespeare <what..._at_xs4all.nl> wrote:
> pianokruk schreef:
>
>
>
> > Hello,
>
> > The following piece of code produces an ora-29294. If I save the
> > contents of the variable uj after the base64 decode to a file, the
> > file is a perfectly valid zip that can be unzipped. What am I missing?
>
> > declare
> > eredeti varchar2(6000) default
> > 'UEsDBBQAAgAIAOZIhzpMHviiHAQAABALAAAjABEAYTE0MjY5MjM3dDAwMTIwMDkw
> > NDA2MDAwMDAwMDE4OC54bWxVVA0AB+cX20nnF9tJ5xfbSb1WPY/jNhDtA+Q/EOr1
> > 7bPXC63ukAR3ua8UuVwQpONKtExbEg2S8q71D1KmT+MyxVXXpRXyvzKkRIlaL26L
> > A+LC8AzfjN6b4YycPL+vSnQkXFBW3zihFziI1BnLaV3cOB9/eeleOc/TRKFcIU8l
> > EVtCJJKnA7lxJLmX/r0oHbTlZHPj4HARLddRvJJBELphoD6hu2EeYKSDKpJTfOMc
> > 8g2k/Pabr0k6z7iVVdmnFC2uSowgcS2UXx6uff/u7s4jByakt2180kOcHnN9L+gM
> > dxd7jBd+BM/wf3v/7kO2JRV2aS0krjMCUYJeC+18xzIsddG+8Bj0CHtFPneALUKJ
> > xuMcS22C4xa3VOCW1UxQydJZOJBaB4tgGfSf8Ooq8R/ghyz7psyZS/N5fOKP/hkO
> > xNAyLQjH3g5Dohc1PZJGgAwT0SMMRbJhBZ7i8C3jEMgxfaG/ddwDkBbrz9UmGSls
> > 6RUpanIkLRFp9wc/dn/XJ0lKUnef5L9/ItF2Zyho4luwIbApThtS7lmeRqBxsoZj
> > IRmvTWlGu2VSuoJx1adHyxwPZQ6WS4+IOPEfiRtzAqkdKU6K1ECUs1p2Z6H5mqOB
> > kG8xSny7CsmG7EqSGSApoYLTQ0B2+pNuDfqe1aIpJQwpesVZc0BvN9JLfIUY4RCr
> > SRptbuQuosQ37hGX0ckAU0sr0ve4OIEIruQUiT94LZzqzaGB2U2/a3J8IEIm/uSz
> > gLSvVRio+0rnhVN3kLWScMX85+687z5nLYVrNzovkDtSlmn3jzQgbVuoLW77560T
> > 3/wetfq2WBi2et/P6cBwFQTxGsq0ehbCNVi6z8K1njQ1ZzOo6aTdoeRIjg+69QP3
> > 0JvuDEOBXnVnmBPU/VWc4GrnFL3mLMcPWva/tSKOvtyKX7tzeWLF041oZIaf6sTq
> > shHqclfAUKavoYj9L+sM72CXPYO7upPs0eYlvlXsYevTemNPOTNa+2UZAYuLsd1T
> > XJYwfE2Vqql3g4UbLEHO5B6hUM+djYzdONRV3j0Abmi7xRJzChfDJA0hqe23wRVs
> > qu4sG4lLvS8G1yREi5P00Aic9psDlNjOEXogdVuTKv3x48vEN8a4dOZFggdNuwbU
> > qfuyN2BtIprDHwLHLgGvyF7dBclx3eJ9RpkbIli4R5LfcrYnHHY/Gg+7zwLl3aed
> > KpOJnGaPmG58+P0NWkVeHHhR7AXq1fHIeq3rEyxRkea3aqMaaw5I3Xg4tKdQSqaw
> > sGV5Gq0DNXG2a44Eh3u1MiD7GG8wvAszAT2Fe2kM+5hwCRV0w9VCA3pz0subIX8Y
> > LAAx2qY/uuZDa+x2JEwIeHlQOb1AIDtnRywvOvQEyaclfqUGQ2zaiIVmX1xwUO45
> > D+254NLjZnzmQMNhAM54WUi1MGwusEbtsprxSP8DUEsBAhcLFAACAAgA5kiHOkwe
> > +KIcBAAAEAsAACMACQAAAAAAAAAAAACAAAAAAGExNDI2OTIzN3QwMDEyMDA5MDQw
> > NjAwMDAwMDAxODgueG1sVVQFAAfnF9tJUEsFBgAAAAABAAEAWgAAAG4EAAAAAA==';
> > uj raw(30000);
> > kicsom raw(30000);
> > begin
> > uj := UTL_ENCODE.BASE64_DECODE(utl_raw.cast_to_raw(eredeti));
> > kicsom:=UTL_COMPRESS.LZ_UNCOMPRESS(uj);
> > end;
> > /
>
> > K
>
> Save to a file and load in a variable again and check the differences.
> My bet: missing an end-of-file character after decoding.
>
> Shakespeare
Hmm, can it be that I want to uncompress a zip file and not a gzip file? When I tried to decompress something which was compressed by utl_compress it worked.
K Received on Fri Apr 17 2009 - 04:02:29 CDT