What is the error message?

Why double quotes "uEQUIPp"

Also Why no END IF

--Amol


-----Original Message-----
From: Sam Cbash
Sent: Thursday, June 28, 2001 9:52 PM
To: LazyDBA.com Discussion
Subject: trigger HELP




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] subscribe: send a blank email to oracledba-[Email Address Removed] 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
Oracle LazyDBA home page