It'll be easier if you can provide us with the error
messages.

But I noticed that you have double quoted the schema
"uEQUIPp".inTrigger. I'm not hundred percent sure but
you might wanna try again without those.

--- Sam Cbash <[Email Address Removed] wrote:
>
>
> Can some one help out debug the code. I just don't
> know why it refuses compile properly.
>
> CREATE OR REPLACE TRIGGER T_EQUIP_ON_UPDATE
> AFTER UPDATE
> OF
> ACTION_PROCESS,
> ACTION_SOURCE,
> ACTION_TYPE,
> ACTIVITY,
> CAL_HOURS,
> IDENT_EQP,
> REPAIR_HOURS
> ON SERVICETEST
> REFERENCING NEW AS NEW_VALUE OLD AS OLD
> FOR EACH ROW
> DECLARE
> errnum NUMBER;
> errmsg VARCHAR2(100);
> v_serviceRec
> service%rowtype
> ;
> UPDATE_FAILED EXCEPTION;
> BEGIN
> IF "uEQUIPp".inTrigger = FALSE THEN
> v_serviceRec.activity:= :new_value.activity ;
> v_serviceRec.ident_eqp:= :new_value.ident_eqp ;
> v_serviceRec.action_process:=
> :new_value.action_process;
> pr_update(:new_value.activity,
> :new_value.ident_eqp,
> :new_value.action_process,
> errnum,
> errmsg);
> end ;
> /
>
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
Oracle LazyDBA home page