Hi Jeff, You want to use ExecuteNonQuery with a stored procedure using the Microsoft data provider for Oracle, rather than ExecuteReader.
Bob Beauchemin [EMAIL PROTECTED] -----Original Message----- From: Jeff Rollins [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 9:33 AM To: [EMAIL PROTECTED] Subject: [DOTNET] .NET and the MS Data Provider for Oracle Beta I'm working with the new Microsoft Data Provider for Oracle Beta. I have an Oracle stored procedure that returns a XML Document in a CLOB datatype. This is returned as a output parameter of the stored procedure. When I try to run ExecuteReader() to execute the stored procedure, I get an error that .NET can not convert the CLOB to a CLR type. Does anyone know how to return a Oracle CLOB to a .NET class? Any suggestions? Thanks, Jeff Error Msg: Exception Details: System.InvalidCastException: Object must implement IConvertible. Error explanation from VS.NET docuemntation: If there is no meaningful conversion to a common language runtime type, then a particular interface method implementation throws InvalidCastException. For example, if this interface is implemented on a Boolean type, the implementation of the ToDateTime method throws an exception because there is no meaningful DateTime equivalent to a Boolean type. Output Parameter set in command object: dbCommand.Parameters.Add(New OracleParameter("docname", OracleType.Clob)).Direction = ParameterDirection.Output - docname is a XML document returned as CLOB from stored procedure. dbCommand.ExecuteReader() You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
