Re: Triggers Compilation Error

Bill West wrote:
>
> 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

You are sure this is a table and not an index? The name sort of suggest an index....
Other than that it looks ok.

Haakon
--
Core Technology AS
Oslo, Norway Received on Thu Oct 15 1998 - 01:52:29 CDT