Re: zip file with PL/SQL procedures

Try this;

1. Write a java class to zip a blob to a blob
2. Load that to the db
3. Write an oracle function that can call the java class
4. Get hold of utl_lob (because utl_file can't write binary files).
5. Put it all together.

I've had to do similar, and its not real easy. An alternative, since you already have the utl_file part working is to just setup an external procedure call that will simply call a C program or "system" call to the zip command.

HTH Paperinik <paperinik_100_at_hotmail.com> wrote in message news:e7473a61dbf4be81c2268c9f6977369b.21356_at_mygate.mailgate.org...
> I write a file with UTL_FILE package.
> Then I want to zip him.
>
> Can you help me please?
>
> Platform: 8i EE + Jserver
>
>
> --
> Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Thu Jan 17 2002 - 04:33:11 CST