SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

A little help with trigger syntax, please...

807762Oct 24 2010 — edited Oct 25 2010

Hey guys, I am trying to create a simple trigger to implement an cascaded updated ...

CREATE OR REPLACE TRIGGER UCRI_CA_G
BEFORE UPDATE OF CA_CODE ON CONSERVATION_AGENCY
FOR EACH ROW

--BEGIN
UPDATE GRANTS SET CA_CODE = :NEW.CA_CODE WHERE CA_CODE = :OLD.CA_CODE;
--END;

I don't understand what the incorrect syntax is here, could someone please give me a hand?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 22 2010

Added on Oct 24 2010

#trigger

3 comments

124 views