Re: Writing binary data to external file

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 11 Aug 2003 07:41:29 -0700
Message-ID: <2687bb95.0308110641.27e0e588@posting.google.com>

"Igor Shulgin" <igor.shulgin_at_chelptt.ru> wrote in message news:<bh7ab1$11gn$1_at_image.surnet.ru>...
> Hi!
>
> What is standard and direct way (within Oracle 9.2 stored procedures)
> for
> writing binary data from Oracle to external file on disk?
> We have tried to use UTL_FILE package, but it operates on files
> consisting out of "line" of size no more than 32767 bytes and adds new_line
> symbol upon closing files.
> Also we checked out interMedia types and packages for writing BLOB to
> disk but now we get stuck with some strange error messages.

Igor, are you using put_raw to perform the write operation?

There is no need to cross-post.

HTH -- Mark D Powell -- Received on Mon Aug 11 2003 - 09:41:29 CDT