Oracle insert storedprocedure and result binding not working

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 6
Joined: Thu 13 Nov 2008 15:14

Oracle insert storedprocedure and result binding not working

Post by 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.

Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by 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?

Post Reply