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
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
Messages: 25577
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

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
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: Trigger problem
Next Topic: cast-ing question
Goto Forum:

Current Time: Mon Aug 21 12:48:29 CDT 2017

Total time taken to generate the page: 0.12333 seconds