Thank you, Tanel.
But I need to _write_ binary data and according "Database Concepts"
(p.355):
"BFILEs are read-only; you cannot modify them"
--
With best wishes,
Igor Shulgin
---------------------------------------------------------------------------
JSC Uralsvyazinform | Applied Systems Department
"Tanel Poder" <change_to_my_first_name_at_integrid.info> wrote in message
news:3f377e71$1_1_at_news.estpak.ee...
> Igor,
>
> Check for BFILE datatype.
>
> Tanel.
>
> "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.
Received on Mon Aug 11 2003 - 06:48:21 CDT
