Re: Utility for creating a ZIP file from BLOBs?

Jeremy schreef:
> Hi
>
> 10g R2 - 10.2.0.1.0 on Linux RHEL4
>
> We have a number of documents in the database stored as BLOBs.
> Increasingly we are being asked to provide a method by which a number of
> these can be delivered to a user as a ZIP file.
>
> The application is web-based and uses the web pl/sql toolkit. I'd rather
> not use any o/s dependent utilities unless absolutely necessary (maximum
> portability).
>
> Does anyone know of such a facility? My googlling hasn't been too
> successful so far on this one.
>
> Many thanks.
>

If you prefer a 100% plsql option, utl_compress might be the way to go. It's gzip-compatible.

See
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/u_compr.htm#BGBJAAJE

or

http://www.psoug.org/reference/utl_compress.html

Shakespeare Received on Mon Dec 01 2008 - 14:35:20 CST