Click here to Skip to main content
11,802,636 members (70,113 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: C# VB 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 KrunalRohit 366
1 OriginalGriff 365
2 F-ES Sitecore 295
3 Afzaal Ahmad Zeeshan 230
4 CPallini 230
0 OriginalGriff 2,950
1 Maciej Los 1,910
2 KrunalRohit 1,862
3 CPallini 1,695
4 Richard MacCutchan 1,157

Advertise | Privacy | Mobile
Web04 | 2.8.151002.1 | Last Updated 1 Feb 2013
Copyright © CodeProject, 1999-2015
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