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_at_news.newsguy.com>
>>> 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.
Date: Wed, 27 Aug 2003 6:08:04 +0800
Message-ID: <0001HW.BB71FB440001FCC1F0284600_at_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 Wed Aug 27 2003 - 00:08:04 CEST