Home » SQL & PL/SQL » SQL & PL/SQL » Read BLOB data using PLSQL
Read BLOB data using PLSQL [message #231340] Mon, 16 April 2007 10:51 Go to next message
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
Re: Read BLOB data using PLSQL [message #231345 is a reply to message #231340] Mon, 16 April 2007 11:16 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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 Go to previous message
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

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


Current Time: Fri Dec 02 22:41:42 CST 2016

Total time taken to generate the page: 0.14353 seconds