hi,
I am trying to read a clob field of an oracle table through oledbcommand but it throws an exception saying "datatype is not supported".
I am using .NET 2.0 with VS2005 not sure about the oracle version of server
public void clob()
{
string strcommodity = null;
string connectionString = "PASSWORD=abc;PERSIST SECURITY INFO=TRUE;USER ID=abc;DATA SOURCE=abc;provider=MSDAORA;";
OleDbConnection OleDbCon = new OleDbConnection(connectionString);
OleDbCommand olecomm = new OleDbCommand("select clobcolumn from table1",OleDbCon);
OleDbCon.Open();
OleDbDataReader oleReader = olecomm.ExecuteReader();
while (oleReader.Read())
{
strcommodity = oleReader.GetString(0);
}
OleDbCon.Close();
oleReader.Close();
}
Any one has any idea if clob is not supported by oledb provider or i am making any mistake...?
pls provide ur input..