Re: Writing binary data to external file

Originally posted by Igor Shulgin
> 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"]news:3f377e71$1_1_at_news.estpak-
> .ee[/url]...
> > Igor,
> > Check for BFILE datatype.
> > Tanel.
> > "Igor Shulgin" <igor.shulgin_at_chelptt.ru> wrote in message
> > news:bh7ab1$11gn$1_at_image.surnet.ru"]news:bh7ab1$11gn$1_at_im-
  age.surnet.ru[/url]...
> > > 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.

I think I provided you a usefull link in same post but different thread. It's your choice to ignore replies to your posts.

Regards
/Rauf Sarwar

--
Posted via http://dbforums.com