Re: Triggers Compilation Error

Tried this code but still getting compilation errors

CREATE OR REPLACE TRIGGER SET_OH_FLAG BEFORE INSERT ON INDEX_FUND_XREF FOR EACH ROW
WHEN (new.FUND LIKE '62100%')
BEGIN
:new.OH_FLAG=1;
END; Other considerations:

1. I own this table
2. The FUND is a char datatype
3. the OH_FLAG is a number with a size of 1 and precision of 0

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 - 12:18:53 CDT