Insert Procedure in oracle which return the new unique ID

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
Posts: 2
Joined: Thu 23 Apr 2009 11:34

Insert Procedure in oracle which return the new unique ID

Post by aloneldi » 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.
209 17 ConsoleApplication1




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

Post by AndreyR » Thu 23 Apr 2009 13:55

This problem was already discussed at our forum here:
We have sent you a workaround.

Post Reply