Re: Writing binary data to external file

    Hi, Mark!

"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message news:2687bb95.0308110641.27e0e588_at_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?

    Yes, we have used put_raw, but it ultimately adds new_line symbol upon closing file. It's unacceptable for us.

--
                       With best wishes,
                                                       Igor Shulgin
---------------------------------------------------------------------------
JSC Uralsvyazinform | Applied Systems Department