Re: Triggers problem

From: Jurij Modic <jmodic_at_src.si>
Date: Thu, 15 Oct 1998 18:33:09 GMT
Message-ID: <36263f43.5707743@news.siol.net>

On Wed, 14 Oct 1998 11:17:01 -0700, "Bill West" <wwest_at_ucsd.edu> 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;
Replace
  :new.OH_FLAG=1;
with
  :new.OH_FLAG := 1;

>Bill West
>SDSC
HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Thu Oct 15 1998 - 13:33:09 CDT