Home » SQL & PL/SQL » SQL & PL/SQL » HELP on Reading ZIP File contents using PL/SQL
HELP on Reading ZIP File contents using PL/SQL [message #250930] Wed, 11 July 2007 21:03 Go to next message
Messages: 1
Registered: July 2007
Junior Member
Hi Guys,

I need your expertise in here guys... I have a requirement that I need to display the zip file contents of a zip file saved on a BLOB field without extracting the said ZIP File. Is it possible with a function hidden somewhere Wink

I'm trying very hard to find such function but fail. Pls. help me guys. Thanks.
Re: HELP on Reading ZIP File contents using PL/SQL [message #250973 is a reply to message #250930] Thu, 12 July 2007 01:52 Go to previous message
Michel Cadot
Messages: 65155
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search for display_zip, display_jpg, display_pdf, display... commands in SQL*Plus. ./fa/451/0/

There are Java classes to zip/unzip. Search for them and build your PL/SQL wrapper on it.
Btw, what do you mean "display a zip content"?

Previous Topic: Character Set in Oracle
Next Topic: ORA-01841: (full) year must be between -4713 and +9999, and not be 0
Goto Forum:

Current Time: Thu Aug 24 01:41:43 CDT 2017

Total time taken to generate the page: 0.06161 seconds