Re: Utility for creating a ZIP file from BLOBs?

On Dec 1, 4:02 pm, Jeremy <jeremy0..._at_gmail.com> wrote:
> 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.
>
> --
> jeremy

Check out my UTL_BinFile package available here: http://www.dynamicpsp.com/prodb/data/Site/ZIPs/freebies/utlbinfile109.zip (Oracle JVM is required for it to operate.) Free for all uses. See accompanying docs for installation and API.

Hth,

   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)    http://www.dynamicpsp.com Received on Mon Dec 01 2008 - 08:15:38 CST