| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Delete trigger does not fire
Mohnish
> CREATE OR REPLACE TRIGGER "WWW".TRIGELEC_HIS_INSERT BEFORE
> INSERT ON "WWW"."TBLELEC" REFERENCING OLD AS o NEW AS n
> FOR EACH ROW
> WHEN (n.ELEC_HIS_ID = 0 OR n.ELEC_HIS_ID = NULL)
Should be:
WHEN (n.ELEC_HIS_ID = 0 OR n.ELEC_HIS_ID IS NULL)
X = NULL is always false
Neil Received on Wed Oct 03 2001 - 15:09:59 CDT
 |
 |