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: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Mon, 11 Aug 2003 14:30:57 +0300
Message-ID: <3f377e71$1_1@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.
>
> --
> With best wishes,
> Igor Shulgin
> --------------------------------------------------------------------------
-
> JSC Uralsvyazinform | Applied Systems Department
>
>
Received on Mon Aug 11 2003 - 06:30:57 CDT

Original text of this message

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