Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Triggers Still a Compilation Problem

Triggers Still a Compilation Problem

From: Bill West <wwest_at_ucsd.edu>
Date: Wed, 14 Oct 1998 11:15:41 -0700
Message-ID: <702pog$283@rosebud.sdsc.edu>


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
SDSC Received on Wed Oct 14 1998 - 13:15:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US