Re: TRIGGER with WHEN clause

KaiGai Kohei wrote:
> I'm uncertain how Oracle handles the condition on the statement
> triggers. But it seems to me WHEN clause on the statement triggers
> are nonsense.

SQL> CREATE TRIGGER dummy BEFORE DELETE ON employees WHEN (1 = 1) 2  BEGIN 3  END; 4  /
CREATE TRIGGER dummy BEFORE DELETE ON employees WHEN (1 = 1)                                               *
ERROR at line 1:
ORA-04077: WHEN clause cannot be used with table level triggers

Yours,
Laurenz Albe