compound trigger - Oracle 11g - bad syntax?
781235Jun 24 2010 — edited Jan 23 2012Hi,
I wanted to use compound trigger in my database but there is a problem with this feature.
My trigger look like this:
-----
CREATE OR REPLACE TRIGGER TEST
FOR UPDATE
ON PATH_$P
COMPOUND TRIGGER
AFTER EACH ROW IS
BEGIN
dbms_output.put_line('after updating row');
END AFTER EACH ROW;
END TEST;
-----
so as you can see it can't be simpler.
An error that I'm getting:
-----
6/19 PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
end before after instead
-----
My Oracle DB version: 11.2.0.1.0
Do you have any idea what is wrong with my code?
Any suggestions will be appreciated :)
Edited by: user10613505 on 2010-06-24 06:25