Click here to Skip to main content
13,404,383 members (36,790 online)
Rate this:
Please Sign up or sign in to vote.
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 1-Feb-13 0:15am
Updated 1-Feb-13 0:44am
Jörgen Andersson 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 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 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
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web01 | 2.8.1802120.2 | Last Updated 1 Feb 2013
Copyright © CodeProject, 1999-2018
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