Click here to Skip to main content
Click here to Skip to main content

Read clob from Oracle

, 5 Jan 2011
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.

License

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#,Asp.net,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 http://dotnetforyou.wordpress.com/ for more technical articles:

Comments and Discussions

 
QuestionThank You Pinmemberbabila3-Jun-14 23:10 
GeneralThank you denzil76 PinmemberAnupama Roy5-Jan-11 3:12 
GeneralReason for my vote of 5 That was very informative Pinmemberdenzil764-Jan-11 22:24 

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

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

| Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 5 Jan 2011
Article Copyright 2010 by Anupama Roy
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid