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!

reading ZIP files through UTL_FILE

626103Oct 13 2009 — edited Oct 13 2009

Hi,

I am using Oracle 10gR2 .Unix is the Operating System. I have a Sample.ZIP file in UTLFILE directory in the database.
My aim is to read the data from Sample.txt file and do further processing, but the file is present in Zipped format. I do not have previleges to write directly into UTLFILE directory.so, I can not unzip it directly using Unix commands.Can you please suggest the way to go ?

Regards,
Naveen.C

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 10 2009

Added on Oct 13 2009

6 comments

1,285 views