Re: Utility for creating a ZIP file from BLOBs?

From: Vladimir M. Zakharychev <>
Date: Mon, 1 Dec 2008 06:15:38 -0800 (PST)
Message-ID: <>

On Dec 1, 4:02 pm, Jeremy <> wrote:
> Hi
> 10g R2 - 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: (Oracle JVM is required for it to operate.) Free for all uses. See accompanying docs for installation and API.


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

Original text of this message