Re: Retrieve the Inserted Key in a after insert trigger

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 25 Aug 2003 17:42:05 -0700
Message-ID: <2687bb95.0308251642.5f22e6bd@posting.google.com>

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<vm9ikvsi2hmp7p9s4q5779qr8ompq2glmq_at_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

Since we are talking about an after insert trigger couldn't the code just reference the :new.keyname like any other row column can be accessed?

HTH -- Mark D Powell -- Received on Mon Aug 25 2003 - 19:42:05 CDT