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

[Joost Evertse]

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
data.
Below is a piece of code that represents what i'm doing.

----
string post="";
			
OracleLob CLOB= dr.GetOracleLob(1);
				
StreamReader streamreader = new
StreamReader(CLOB,System.Text.Encoding.Default);
				
post = streamreader.ReadToEnd();
Response.Write("adding : " + post);
-----

Does anyone have a clue?

regards,
Joost Evertse