Re: care and feeding of triggers

From: Gerard Averill <gaverill_at_chsra.wisc.edu>
Date: 11 Oct 2000 21:14:00 GMT
Message-ID: <8FCAA7F9Agaverill@144.92.88.10>

tony_barratt_at_my-deja.com wrote in <8s2acq$lii$1_at_nnrp1.deja.com>:

>Hi List,
>I'm still struggling with a procedure and a trigger maybe someone can
>put me, and my code, right..
>

<snip>

>select * from user_errors;
><snip>
>WRITE_ALARMS_ON_I TRIGGER 1
>12 37
>PLS-00201: identifier 'NEW.AGENT_ID' must be declared
>WRITE_ALARMS_ON_I TRIGGER 2
>12 1
>PL/SQL: Statement ignored
>20 rows selected.
>
>I sort of thought that agent_id would be visible cos it's in the alarm
>table, but maybe not?
>

I believe you need to use a colon in front of the NEW (same for the NEW.NODE_TYPE, too) just as you did earlier in the trigger body.

HTH,
g Received on Wed Oct 11 2000 - 16:14:00 CDT