Re: Passing an argument to a trigger?

Ramon F Herrera wrote:

> 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

I don't think you understand what FOR EACH ROW means? It has to do with when the trigger is fired and when it is not fired.

To access each row you must use FOR EACH ROW. And to access the values inserted you must use the :NEW bind variable.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)