PLS-00103: Encountered the symbol
create or replace TRIGGER "BGV_T1"
after insert or update on "BGV"
for each row
begin
if updating then
"MAIL_SENT" = 'No'
where "Change_Reason" = 'Offer Accepted by Applicant';
end;
/
___________________________
Error
Compilation failed, line 4 (23:50:39) The line numbers associated with compilation errors are relative to the first BEGIN statement. This only affects the compilation of database triggers.
PLS-00103: Encountered the symbol "WHERE" when expecting one of the following: * & = - + ; < / > at in is mod remainder not rem <> or != or ~= >= <= <> and or like like2 like4 likec between || multiset member submultiset Compilation failed, line 5 (23:50:39) The line numbers associated with compilation errors are relative to the first BEGIN statement. This only affects the compilation of database triggers.
PLS-00103: Encountered the symbol "END"