Entity Framework 4.0 - Insertion Procedure
839597Feb 16 2011 — edited Jul 14 2011Hi,
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