Getting error Invalid operation

abhinay_agrawal · Post by **abhinay_agrawal** » Mon 09 Nov 2009 15:08

Hi,

I am using Devart Oracle for Entity Framework while executing stored procedure I am going to take each cursor as of type Data reader

by using using (OracleDataReader reader = ((OracleCursor)(oraParam.Value)).GetDataReader()) and it's throwing

((OracleCursor)(oraParam.Value)).GetDataReader()
'((OracleCursor)(oraParam.Value)).GetDataReader()' threw an exception of type 'System.InvalidOperationException'
base {System.SystemException}: {""}

I am using EFEaxtension for executing Stored Procedure in my GetInvoices stored procedure I am returning 7 ref_cursors... please let me know where I am doing wrong in one project it's working fine and in another it's not working....

for executing sp I am using following code...
using (cmd.Connection.CreateConnectionScope())
{
//Execute SP
cmd.ExecuteNonQuery();
}

also I am getting error while clicking on show license information it's complaining that

Object reference is not set to instance of an object

I am using Devart Dotconnect for oracle 5.25 professional evaluation edition.

Thanks,
Abhinay Agrawal.

AndreyR · Post by **AndreyR** » Tue 10 Nov 2009 16:12

Could you please send me (support * devart * com, subject "EF Extensions & 7 cursors") a small test project illustrating the problem?

abhinay_agrawal · Post by **abhinay_agrawal** » Fri 13 Nov 2009 10:26

HI AndreyR,

It's gets resolved when I changed dattype DATE to TIMESTAMP(2) in oracle and it's working properly.

Thanks,
Abhinay.

AndreyR · Post by **AndreyR** » Fri 13 Nov 2009 12:15

Glad to hear it.
But I'd still ask you to make a test project to help us improve the product.