Re: care and feeding of triggers

In article <8FCAA7F9Agaverill_at_144.92.88.10>,   gaverill_at_chsra.wisc.edu (Gerard Averill) wrote:
> 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
>

And I believe the command is show errors trigger triggername. If you misspell the trigger name it doesn't tell you either, just reports no errors.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 13 2000 - 11:42:47 CDT