Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Retrieve the Inserted Key in a after insert trigger

Re: Retrieve the Inserted Key in a after insert trigger

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sun, 24 Aug 2003 22:59:31 +0200
Message-ID: <vm9ikvsi2hmp7p9s4q5779qr8ompq2glmq@4ax.com> 





On Sun, 24 Aug 2003 18:18:02 +0200, "Guy Van Rinsveld"
<guyvanrinsveld_at_hotmail.com> wrote:



>So, my CURRVAL is not the correct answer to this, following you ?




It could be the correct answer, provided you do it in a after insert
for each row trigger. However, you'll need to select the currval, and
a different process *may* have incremented the sequence.




Sybrand Bakker, Senior Oracle DBA



To reply remove -verwijderdit from my e-mail address
Received on Sun Aug 24 2003 - 15:59:31 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US