Skip to Main Content

Oracle Developer Tools for Visual Studio

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Entity Framework 4.0 - Insertion Procedure

839597Feb 16 2011 — edited Jul 14 2011
Hi,

I have installed the new Oracle EF 4 enabled ODP.net and was able to get it working with stored procedures returning sys_refcursor (thanks to the people who gave me answers on this forum).

Now I would like to have a stored procedure that I can call to send a new entity and get back the ID (internal key) as an output parameter and store it in the entity. I am able to assign it to an entity and even map the output parameter but I get the following error when I try to use it.

"+Error 2047: A mapping function binding specifies a function Model.Store.PKG_X.CREATE_NEW with an unsupported parameter: PID. Output parameters may only be mapped through the RowsAffectedParameter property. Use result bindings to return values from a function invocation.+"

From researches I did on google, it seems that the EF 4 does not support output parameters. They support binding variables of some kind for SQL Server. How can this scenario be done within Oracle? I absolutely want Oracle to handle the values assigned to the primary keys.

Thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 11 2011
Added on Feb 16 2011
5 comments
827 views