Re: how to zip a csv file in a oracle procedure
Date: Thu, 27 Dec 2007 04:00:08 -0800 (PST)
I cannot use external package (i'm not the database owner) sorry and thanks for the tips
On 27 Dic, 12:53, "Vladimir M. Zakharychev"
> On Dec 27, 12:27 pm, mpacilio2..._at_gmail.com wrote:
> > Hi
> > i need to zip a csv inside an oracle procedure.
> > I create this file (120 MB) inside a procedure and i leave it in a
> > shared folder but i need to zip it
> > Is it possible calling an oracle command?
> > Please help me
> > Thanks in advance
> Try UTL_BinFile package available athttp://www.dynamicpsp.com/prodb/data/Site/ZIPs/freebies/utlbinfile109...
> (sorry if this looks like an ad, the package is non-commercial.) The
> docs are inside, the only prerequisite is that target database has
> Java VM installed (that is, it won't work on Oracle XE.) With this
> package, you can create ZIP archives stored both externally, in the
> server file system, and internally, in a BLOB.
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
Received on Thu Dec 27 2007 - 06:00:08 CST