Even if I am executing all of this inside a transaction, don't I still have concurrency issues with this approach?
-----Original Message----- From: Larry Meadors [mailto:[EMAIL PROTECTED] Sent: Thursday, May 08, 2008 5:12 PM To: [email protected] Subject: Re: How to get the generated key from insert with Oracle I think this would be the preferred SQL for that: select ids.currval from dual ...where ids is your sequence's name. Larry No virus found in this incoming message. Checked by AVG. Version: 8.0.100 / Virus Database: 269.23.10/1421 - Release Date: 5/7/2008 5:23 PM
