Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# Windows Oracle VB.NET
Hello All,
I need some help in extracting images from oracle clob column using C#/VB.NET. Basically I have a oracle table which contains student name as varchar2 and one clob column which contains some binary data (image/pdf files). I have to extract that files from table to disc. Any help from your side is highly appreciated.
 
Regards,
Sunil Tiwari.
[Emailid-Deleted]
Posted 31-Jan-13 23:15pm
Edited 31-Jan-13 23:44pm
v2
Comments
Jörgen Andersson at 2-Feb-13 15:38pm
   
CLOB is for storing characters, not binaries. Have you written it wrong and it is actually a BLOB field?
Or are you encoding the binaries to text? (for example base64) And in this case WHY?
Or has someone f***ed up?

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Soooo...what did you do to get the files in there in the first place?? The process would be exactly the same, only in reverse. BTW, this is implementation specific! There's more than one way to get a file into a column in a database.
  Permalink  
Comments
Sunil Tiwari at 4-Feb-13 0:16am
   
My Query is quite different..... I have a oracle table which contains colb column in table. I know that clobs are image files [JpegInTiff] format which I want to extract on disc.
Dave Kreskowiak at 4-Feb-13 8:15am
   
Again, what did you do to put the files in that column in the first place?? You just do the steps in the opposite order, of course, accounting for writing files instead of reading them.

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



Advertise | Privacy | Mobile
Web03 | 2.8.141022.2 | Last Updated 1 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100