Writing binary data to external file

[Igor Shulgin]

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

[Rauf Sarwar]

Originally posted by Igor Shulgin

Thank you, Tanel.
But I need to _write_ binary data and according "Database
Concepts"
(p.355):
"BFILEs are read-only; you cannot modify them"
--
With best wishes,
Igor Shulgin
--------------------------------------------------------------------
--------
JSC Uralsvyazinform | Applied Systems Department
"Tanel Poder" <ch*********************@integrid.info> wrote in message
news:3f**********@news.estpak.ee"]news:3f**********@news.estpak-
.ee[/url]...

Igor,
Check for BFILE datatype.
Tanel.
"Igor Shulgin" <ig**********@chelptt.ru> wrote in message
news:bh***********@image.surnet.ru"]news:bh7ab1$11gn$1@im-

age.surnet.ru[/url]...

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.

I think I provided you a usefull link in same post but different thread.
It's your choice to ignore replies to your posts.

Regards
/Rauf Sarwar

--
Posted via http://dbforums.com

[Mark D Powell]

"Igor Shulgin" <ig**********@chelptt.ru> wrote in message news:<bh***********@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 --

[Frank]

Mark D Powell wrote:

"Igor Shulgin" <ig**********@chelptt.ru> wrote in message news:<bh***********@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

--
Regards, Frank van Bortel

[steve]

On Tue, 19 Aug 2003 4:03:05 +0800, Frank wrote
(in message <bh**********@news2.tilbu1.nb.home.nl>):

Mark D Powell wrote:

"Igor Shulgin" <ig**********@chelptt.ru> wrote in message
news:<bh***********@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