Error in accessing CLOB data

Administrator

Hi, I have to access a CLOB data from Oracle database. I have used the 'System.Data.OracleClient' namespace and while coding, the quick list gives all its objects and works fine as I got in sample codes. But when I run the application, I got this error message: "The type or namespace name 'System.Data.OracleClient' does not exist in the class or namespace 'System.Data' (are you missing an assembly reference?)" What is the reason and also send me the solution. How I can get the value of CLOB data type. Can I get this value from normal DataReader object. Plz reply urgently............

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Administrator23y ago
Hi, I think the Oracle drivers are a separate install from .NET. 1 - have you installed the drivers? 2 - have you added a reference to System.Data.OracleClient.dll? Also, I'd look at the OracleHelper application block from Microsoft, apart from specific oracle types it pretty much replicates the interface of SqlHelper...so you don't really have to deal with Oracle related issues unless absolutely necessary. Cheers,
+1
Administrator23y ago
Have you referenced the dll properly in "References" in your project? If not, "Add reference", and choose the 'System.Data.OracleClient.dll' Here is some code that works for me: string sSql = "UPDATE table SET column = :LongText WHERE column = " + TbKey.Text; string connectionString = ConfigurationSettings.AppSettings.Get("connectionString"); OracleConnection connection = new OracleConnection(connectionString); connection.Open(); OracleCommand cmd = new OracleCommand(sSql, connection); OracleParameter param = new OracleParameter("LongText", System.Data.OracleClient.OracleType.Clob); param.Value = TextBoxText.Text; cmd.Parameters.Add(param); cmd.ExecuteNonQuery();
+1