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

Home -> Community -> Usenet -> c.d.o.server -> Passing an argument to a trigger?

Passing an argument to a trigger?

From: Ramon F Herrera <ramon_at_conexus.net>
Date: 14 Nov 2004 13:27:21 -0800
Message-ID: <c9bc36ff.0411141327.6045dcde@posting.google.com>


This is my first trigger.

I need the trigger to fire every time there is an INSERT in a table. That part works well, but I need to have access to the record that got inserted.

It seems that the only way to achieve this is by using FOR EACH ROW and :new

Is there any way to get the argument that I need _without_ using the "FOR EACH ROW" method?

TIA, -Ramon Received on Sun Nov 14 2004 - 15:27:21 CST

Original text of this message

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