Insert Procedure in oracle which return the new unique ID
Posted: Thu 23 Apr 2009 11:42
I created 3 procedures :
Insert,Update and Delete.
The update and Delete are getting only input parameters.
The insert is returning the new unique id of the row.
How do I map the out parameter for the insert procedure ?
When saving the new Model I'm getting the error :
**********************************************
Error 1 Error 2047: A mapping function binding specifies a function Model.Store.INSERTCONTACT
with an unsupported parameter: O_CONTACT_ID. Output parameters may only be
mapped through the RowsAffectedParameter property.
Use result bindings to return values from a function invocation.
C:\C#\EntityFrameWork\ConsoleApplication1\ConsoleApplication1\Model1.edmx
209 17 ConsoleApplication1
*****************************************************
Thanks
Alon
Insert,Update and Delete.
The update and Delete are getting only input parameters.
The insert is returning the new unique id of the row.
How do I map the out parameter for the insert procedure ?
When saving the new Model I'm getting the error :
**********************************************
Error 1 Error 2047: A mapping function binding specifies a function Model.Store.INSERTCONTACT
with an unsupported parameter: O_CONTACT_ID. Output parameters may only be
mapped through the RowsAffectedParameter property.
Use result bindings to return values from a function invocation.
C:\C#\EntityFrameWork\ConsoleApplication1\ConsoleApplication1\Model1.edmx
209 17 ConsoleApplication1
*****************************************************
Thanks
Alon