Click here to Skip to main content
Rate this: bad
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.
Sunil Tiwari.
Posted 31-Jan-13 23:15pm
Edited 31-Jan-13 23:44pm
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
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.
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)

  Print Answers RSS
0 OriginalGriff 279
1 Maciej Los 168
2 George Jonsson 154
3 Sarvesh Kumar Gupta 130
4 Dave Kreskowiak 130

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