Syntax issue with trigger trying to update same table

  1. vinipathak

    vinipathak Starter

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Delhi
    I am getting issue with following trigger condition i have written.
    It is throwing error where it is not expecting the = operator in if block.
    Where am i going wrong?


    begin

    if :new.APPROVE_THIS = 'Y'
    then :new.APPROVED=1 ;
    end if;
     
    Last edited: Apr 29, 2020