Re: Utility for creating a ZIP file from BLOBs?
Date: Mon, 1 Dec 2008 06:15:38 -0800 (PST)
On Dec 1, 4:02 pm, Jeremy <jeremy0..._at_gmail.com> wrote:
> 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
> Does anyone know of such a facility? My googlling hasn't been too
> successful so far on this one.
> Many thanks.
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.
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Mon Dec 01 2008 - 08:15:38 CST