SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to read a Zip file in PL/SQL program

703794Nov 23 2011 — edited Mar 11 2012

Hi,

I was Reading a ".csv" file from a web URL eg. "www.aba.com/zxc.csv" in my PL/SQL procedure using UTL_HTTP package and loading data in my DB.

Now that file is in .zip format, is there any way that I can still read that .csv.zip file through my PL/SQL procedure. Because now I have to download it first then
unzip it and then I am loading it into my DB using UTL_FILE package instead I want to do it automatically as I was doing it before when it was not zipped.

Thanks & Regards
Sanjay

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 8 2012

Added on Nov 23 2011

6 comments

3,167 views