Getting the id value generated by an insert statement

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 1
Joined: Fri 25 Feb 2011 22:19

Getting the id value generated by an insert statement

Post by andy_clem » Fri 25 Feb 2011 22:42


Can debate do this?

I am looking for a data provider that enables me to use pl/SQL stored procedures for inserting data into oracle tables.

I then want to be able to use the Id column generated by the stored procedure in visual studio.

The new oracle provider nearly does it, but it is very cumbersome and I just wondered whether devart's product is a bit slicker?

Any experiences from real world solutions appreciated.

I want to be able to reference the Id column generated from an oracle sequence

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

Post by AndreyR » Mon 28 Feb 2011 13:01

Are you using any ORM like Entity Framework?
We have mentioned an EF tip concerning using the returned value set by trigger.
Could you please describe in details the scenario and data access approach you plan to implement?

Post Reply