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.
