Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Writing binary data to external file
"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?
There is no need to cross-post.
HTH -- Mark D Powell -- Received on Mon Aug 11 2003 - 09:41:29 CDT