Unable to cast object of type 'System.DBNull' to type 'CoreLab.Oracle.OracleObject'
Posted: Wed 26 Mar 2008 20:30
I am calling an Oracle Package that returns nested UDT's that conform to an XML schema. It seems to work fine for most data but I have run into an instance with certain data where I receive this error: Unable to cast object of type 'System.DBNull' to type 'CoreLab.Oracle.OracleObject'. Apparently there is a problem converting the returned UDT.
I can call the package using SQL+ and it executes successfully.
Is there any way to debug this to figure out why the OraDirect.Net package throws an error while SQL+ returns data?
Here is the code that makes the call: where col=collection of strongly-typed parameters.
I have downloaded the latest version of OraDirect.Net v4.50.31 - and am using .net framework 2.0.
Thanks[/code]
I can call the package using SQL+ and it executes successfully.
Is there any way to debug this to figure out why the OraDirect.Net package throws an error while SQL+ returns data?
Here is the code that makes the call:
Code: Select all
return (OracleObject)package.ExecuteProcedure(OracleFunctionName, col, true)
I have downloaded the latest version of OraDirect.Net v4.50.31 - and am using .net framework 2.0.
Thanks[/code]