Re: help getting a trigger inserted value

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 28 Sep 2000 08:23:33 +0100
Message-ID: <970126427.28461.1.nnrp-12.9e984b29@news.demon.co.uk>

Look at my website under

faq -> autonumber

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Greg Gale wrote in message <8qtnbp$k09$1_at_nnrp1.deja.com>...


>I'm looking for some help with getting the a value inserted by a

>trigger. I'm populating the primary key of a table using an insert row

>trigger which grabs the number from a sequence. How do I get the value

>that was inserted by the trigger so I can pass it to a procedure after

>inserting the row.

>

>Thanks.

>

>

>

>

>Sent via Deja.com http://www.deja.com/

>Before you buy.

Received on Thu Sep 28 2000 - 02:23:33 CDT