471,083 Members | 1,066 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,083 software developers and data experts.

Writing binary data to external file

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
Jul 19 '05 #1
4 8821

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
Jul 19 '05 #2
"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 --
Jul 19 '05 #3
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

Jul 19 '05 #4
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

Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by john smith | last post: by
6 posts views Thread by Sebastian Kemi | last post: by
5 posts views Thread by rob | last post: by
6 posts views Thread by DanielEKFA | last post: by
103 posts views Thread by Steven T. Hatton | last post: by
3 posts views Thread by nicolasg | last post: by
6 posts views Thread by arne.muller | last post: by
4 posts views Thread by Igor Shulgin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.