Re: Writing binary data to external file

From: steve <me_at_me.com>
Date: Wed, 27 Aug 2003 6:08:04 +0800
Message-ID: <0001HW.BB71FB440001FCC1F0284600@news.newsguy.com>

On Tue, 19 Aug 2003 4:03:05 +0800, Frank wrote (in message <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_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 --
> 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
> 
> 

use the java file packages, there you have no limit.

steve Received on Tue Aug 26 2003 - 17:08:04 CDT