Hi everyone,

This is my first post on the newsgroup so please be kind to a newbie.
I have the following code for an Oracle 10g table trigger

create or replace trigger chk_multi_dup
  after insert or update on epics.actor_attribute
  for each statement

SQL PLUS complains that it is expecting "for each row"...however, I
truly do want it to be for each statement.

The Great Pawn Hunter

The Great Pawn Hunter schrieb:

Row level trigger requires "FOR EACH ROW" clause.
If you omit the above, dml trigger is statement level trigger.

The one of the fastest alternatives (compared to any other) to check,
whether syntax you used is correct is to lookup it in the documentation.
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/sta...

Best regards

Maxim