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;
Bill West wrote in message <700n2v$7nt_at_rosebud.sdsc.edu>...
>Can anyone spot the syntax error in the statement below:
>
>CREATE OR REPLACE TRIGGER SET_OH_FLAG AFTER INSERT ON INDEX_FUND_XREF
>FOR EACH ROW
>WHEN (new.FUND LIKE '62100%')
>BEGIN
>UPDATE INDEX_FUND_XREF SET :new.OH_FLAG=1;
>END;
>
>
>I keep getting compilation errors.
>
>TIA
>
>Bill West
>SDSC
>
>
Received on Wed Oct 14 1998 - 01:07:54 CDT
