Oracle does not allow a when clause on an instead of trigger.
when new.key=old.key
*
ERROR at line 3:
ORA-25004: WHEN clause is not allowed in INSTEAD OF triggers
[EMAIL PROTECTED] wrote: Ticket #2282 against SQLite
http://www.sqlite.org/cvstrac/tktview?tn=2282
complains that in an INSTEAD OF trigger on a view where
the trigger has a WHEN clause, if the WHEN clause is false
and the trigger does not fire, then the UPDATE statement
that provoked the trigger should fail. I am skeptical
of this claim, but want the opinion of others before
I reject the ticket.
Is this really a bug? What do INSTEAD OF triggers with
false WHEN clauses do on other SQL database engines?
--
D. Richard Hipp
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
