Re: Writing binary data to external file
From: Frank <fvanbortel_at_netscape.net>
Date: Mon, 18 Aug 2003 22:03:05 +0200
Message-ID: <bhrb39$hs0$1_at_news2.tilbu1.nb.home.nl>
>
>
> Igor, are you using put_raw to perform the write operation?
>
> There is no need to cross-post.
>
> HTH -- Mark D Powell --
afaicr, Tom Kyte stated that the 32k is a utl_file boundary. You will have to use another program, or the LOB packages, as you suggested. Without the actual errors, no dice
Date: Mon, 18 Aug 2003 22:03:05 +0200
Message-ID: <bhrb39$hs0$1_at_news2.tilbu1.nb.home.nl>
Mark D Powell wrote:
> "Igor Shulgin" <igor.shulgin_at_chelptt.ru> wrote in message news:<bh7ab1$11gn$1@image.surnet.ru>...
>
>>Hi! >> [Quoted] >> 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 --
afaicr, Tom Kyte stated that the 32k is a utl_file boundary. You will have to use another program, or the LOB packages, as you suggested. Without the actual errors, no dice
-- Regards, Frank van BortelReceived on Mon Aug 18 2003 - 22:03:05 CEST