Click here to Skip to main content
12,952,792 members (35,370 online)
Click here to Skip to main content
Add your own
alternative version

Tagged as


2 bookmarked
Posted 28 Dec 2010

Read clob from Oracle

, 5 Jan 2011 CPOL
Rate this:
Please Sign up or sign in to vote.
Read clob from Oracle
What comes to your mind first when I say clob? Well, don't worry if you are not able to think anything about it. It’s nothing but a type used to store 4 GB of data in the database. I work with an Oracle db & today had to read a clob out parameter from Oracle procedure in .NET. Infact, I had to rewrite some code as the out param was initially of type varchar & then changed to clob. It’s a bit tricky & Google din’t come to my rescue this time & I figured it out using watch window of Visual Studio.

Code I had written when the out param was varchar is as below:

errorCode = Params[3].Value.ToString();

and re written as below to read a clob:

errorCode = ((Oracle.DataAccess.Types.OracleClob)(Params[3].Value)).Value.ToString();

Hope this snippet comes to your mind when you deal with Oracle datatypes like BFile, Blob, Clob, Binary, etc.


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


About the Author

Anupama Roy
Software Developer (Senior) Dell
India India
I am a .Net developer working on C#,,WCF,WF etc.I would like to utilize this space to share whatever I have come across so far working in .Net so that you can also learn & explore.

I hope you find these posts useful.I’d love to hear from you,so please post in your comments/feedback.

Visit my blog for more technical articles:

You may also be interested in...


Comments and Discussions

QuestionThank You Pin
babila3-Jun-14 23:10
memberbabila3-Jun-14 23:10 
GeneralThank you denzil76 Pin
Anupama Roy5-Jan-11 3:12
memberAnupama Roy5-Jan-11 3:12 
GeneralReason for my vote of 5 That was very informative Pin
denzil764-Jan-11 22:24
memberdenzil764-Jan-11 22:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170525.1 | Last Updated 5 Jan 2011
Article Copyright 2010 by Anupama Roy
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid