Oracle insert storedprocedure and result binding not working

Oracle insert storedprocedure and result binding not working

Postby Varun » Fri 28 Nov 2008 18:29

I need to get the ID for an inserted row back from the database. I have done this in EF with stored proc mapping and setting the result binding, I am using INSERT WITH RETURNING clause for my stored procedure. Execution of this end up with the error below. I tried doing the same with a SQL Server stored procedure and it works like a charm.

The data reader is incompatible with the specified 'CSRModel.TESTTABLE'. A member of the type, 'ID', does not have a corresponding column in the "data reader with the same name.."

Has anyone successfully mapped an oracle insert stored procedure in the EF designer if so could you please post the oracle stored procedure used for the insert.
Varun
 
Posts: 6
Joined: Thu 13 Nov 2008 15:14

Postby AndreyR » Tue 02 Dec 2008 09:09

Could you please send me (andreyr * devart * com) a test project containing your SP and table definitions, and the .edmx file?
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle