[Mono-devel-list] System.Data.OracleClient and CLOB's

Joost Evertse j.evertse at cloudseven.nl
Thu Jan 6 18:54:11 EST 2005

I've been trying to get data from an CLOB column in oracle in to a string
to display on my ASP.NET webpage (mod_mono)
I already tried to let the clob.value.getstring() method do the conversion
for me but that gives me an exception about arguments not being even.
I tried another way, by connecting a stream reader to read bytes into
chars en put it in a string. But the funny thing is that it doesn't return
enough data from the record. I also tried to alter the buffersizes, but to
no avail. It always cuts data at some point. No errors, but not enough
Below is a piece of code that represents what i'm doing.

string post="";
OracleLob CLOB= dr.GetOracleLob(1);
StreamReader streamreader = new
post = streamreader.ReadToEnd();
Response.Write("adding : " + post);

Does anyone have a clue?

Joost Evertse

More information about the Mono-devel-list mailing list