Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Writing binary data to external file

Re: Writing binary data to external file

From: Igor Shulgin <igor.shulgin_at_chelptt.ru>
Date: Tue, 12 Aug 2003 10:52:10 +0600
Message-ID: <bh9rpp$207s$1@image.surnet.ru>

    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
Received on Mon Aug 11 2003 - 23:52:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US