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 Compilation Error

Triggers Compilation Error

From: Bill West <wwest_at_ucsd.edu>
Date: Tue, 13 Oct 1998 16:17:48 -0700
Message-ID: <700n2v$7nt@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 Tue Oct 13 1998 - 18:17:48 CDT












Original text of this message













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