Click here to Skip to main content
15,884,099 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,
I need a C# console application code to extract a Blob feild from a oracle 11g table to a pre-defined folder.
The Blob feild contains pdf file.
Please help me on how to do this.

Thanks a lot in advance,i am in dire need of this help ASAP.

Thanks
Posted
Updated 6-Feb-12 6:29am
v2
Comments
theanil 6-Feb-12 12:30pm    
don't write urgent word in question

Hi,

Here[^] you have exactly what you need. You only have to adjust code to read from your tables and right connection to oracle...

Next two examples are showing read/write image from oracle, but you will get the point, because basicly blob is just byte[] and you need to write it into file with proper extension using stream writer or similar class for that purpose...
1. Insert /retrieve an image into/ from a blob field in Oracle database using C#.Net[^]
2. http://www.akadia.com/services/dotnet_orablobs.html[^]
 
Share this answer
 
Thanks a Lot Martin for your help.
I did as you adviced and got the answer.
I will get back to you guys if i find any further questions on the same.

Thanks
 
Share this answer
 
Comments
Christian Graus 7-Feb-12 12:22pm    
Please don't hit 'answer' to post a comment. This is not an answer. You should delete it, and use the 'question or comment' button for this.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900