Oracle Trigger Syntax Error

[Yelellav]

I am trying to create a trigger in oracle but when I run the code I get the following:

Warning: Trigger created with compilation errors.

Can anyone help me?

CREATE OR REPLACE TRIGGER stoplight_flag_to_zero
AFTER UPDATE OF status ON projects
FOR EACH ROW
WHEN (old.status = 'Active')
BEGIN
update qa_review
set stoplight_flag = 0
where project_id = ld.id;
END stoplight_flag_to_zero
/

 

[Turkbear]

Hi,
Try typing SHOW ERROR after the message and see if it is more specific..

 

[ThomVF]

Don't think you need to specify the trigger name after "END" (like a function/procedure) and you may need a semi-colon there
"Helping others to help themselves..."
=================================
Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com

 

[Yelellav]

Thanks! That showed me the problem.