OraFAQ Forum: SQL & PL/SQL » Read BLOB data using PLSQL

Home » SQL & PL/SQL » SQL & PL/SQL » Read BLOB data using PLSQL

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Read BLOB data using PLSQL [message #231340]

Mon, 16 April 2007 10:51

sachin_goel
Messages: 1
Registered: April 2007

Junior Member

Hi All,

I have to read BLOB format data from an Oracle Table using PLSQL. Can any body help me in this.

Thanks & Regards
Sachin Goel

Report message to a moderator

Re: Read BLOB data using PLSQL [message #231345 is a reply to message #231340]

Mon, 16 April 2007 11:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Can any body help me in this.
As opposed to you helping yourself by using GOOGLE?
Results 1 - 10 of about 94,400 for Read BLOB data using PLSQL oracle
Are you claiming that NONE of the 90000 answer your question?
such as
How to: Read and Write BLOB Data to a Database Table Through an Anonymous PL/SQL Block
http://www.oracle.com/technology/sample_code/tech/windows/odpnet/howto/anonyblock/index.html

Please explain why a simple RTFM question is deemed EXPERT level?

[Updated on: Mon, 16 April 2007 11:24] by Moderator

Report message to a moderator

Re: Read BLOB data using PLSQL [message #232868 is a reply to message #231345]

Mon, 23 April 2007 13:37

thorin666
Messages: 144
Registered: March 2007

Senior Member

anacedent i readed your link but the answer is using C# or VB, and the tittle of the post is "Read BLOB data using PLSQL" not using C or VB.
A friend told me that you must use dbms_lob to loop through, using the utl_file raw API to pump it to a file.

But i dont understand because i though that utl_file is to txt and not binary

Report message to a moderator

Previous Topic:	Oracle Trace (Debug) Files
Next Topic:	Trigger problem??

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 19:30:49 CDT 2024