Re: Triggers Compilation Error

Philippe ARNAUD wrote in message <701f5q$af1$1_at_concorde.ctp.com>...
>CREATE OR REPLACE TRIGGER SET_OH_FLAG AFTER INSERT ON INDEX_FUND_XREF
>FOR EACH ROW
>WHEN (new.FUND LIKE '62100%')
>BEGIN
> :new.OH_FLAG=1;
>END;
>

One remark - trigger must be BEFORE, not AFTER. Received on Wed Oct 14 1998 - 04:49:04 CDT