title: PLS-00049: bad bind variable
body: <p>I'm trying to write a trigger but I'm getting this error:</p>
  
  <pre><code>Error(44,3): PLS-00049: bad bind variable 'NEW.NEW_REGION_CODE'
  Error(45,5): PLS-00049: bad bind variable 'NEW.NEW_REGION_DESC'
  Error(46,5): PLS-00049: bad bind variable 'NEW.NEW_MYHR_REGION_BI_CODE'
  Error(47,3): PLS-00049: bad bind variable 'NEW.NEW_MEDBEN_NUMOF_OPTIONS'
  Error(48,5): PLS-00049: bad bind variable 'NEW.NEW_DENTALBEN_NUMOF_OPTIONS'
  Error(49,3): PLS-00049: bad bind variable 'NEW.NEW_NUMOFHRS_WORKD_60PRORATION'
  Error(50,5): PLS-00049: bad bind variable 'NEW.NEW_NUMOFHRS_WORKD_80PRORATION'
  Error(51,5): PLS-00049: bad bind variable 'NEW.NEW_CREATED_BY'
  Error(52,3): PLS-00049: bad bind variable 'NEW.NEW_CREATED_ON'
  </code></pre>
  
  <p>Here is my trigger code:</p>
  
  <pre><code>CREATE OR REPLACE 
  TRIGGER TRG_UPDT_REGION
  BEFORE UPDATE ON REGION 
  FOR EACH ROW
  BEGIN
      INSERT INTO REGION_HST 
  ( 
  REGION_CODE, 
  REGION_DESC, 
  MYHR_REGION_BI_CODE, 
  MEDBEN_NUMOF_OPTIONS, 
      DENTALBEN_NUMOF_OPTIONS, 
  NUMOFHRS_WORKED_60PRORATION,
  NUMOFHRS_WORKED_80PRORATION,
  CREATED_BY,
  CREATED_ON, 
  UPDATED_BY, 
  UPDATED_ON,
  DELETED_BY,
  DELETED_ON, 
      NEW_REGION_CODE,
  NEW_REGION_DESC, 
  NEW_MYHR_REGION_BI_CODE, 
  NEW_MEDBEN_NUMOF_OPTIONS, 
  NEW_DENTALBEN_NUMOF_OPTIONS, 
      NEW_NUMOFHRS_WORKD_60PRORATION,
  NEW_NUMOFHRS_WORKD_80PRORATION, 
  NEW_CREATED_BY, 
  NEW_CREATED_ON, 
  NEW_UPDATED_BY, 
  NEW_UPDATED_ON
  )
      VALUES 
      ( 
  :OLD.REGION_CODE, 
  :OLD.REGION_DESC, 
  :OLD.MYHR_REGION_BI_CODE, 
      :OLD.MEDBEN_NUMOF_OPTIONS,
  :OLD.DENTALBEN_NUMOF_OPTIONS,
  :OLD.NUMOFHRS_WORKED_60PRORATION, 
      :OLD.NUMOFHRS_WORKED_80PRORATION, 
  :OLD.CREATED_BY,
  :OLD.CREATED_ON,
  :OLD.UPDATED_BY, 
      :OLD.UPDATED_ON,
  APEX_APPLICATION.G_USER,
  SYSDATE, 
      :NEW.NEW_REGION_CODE,
  :NEW.NEW_REGION_DESC, 
  :NEW.NEW_MYHR_REGION_BI_CODE, 
      :NEW.NEW_MEDBEN_NUMOF_OPTIONS, 
  :NEW.NEW_DENTALBEN_NUMOF_OPTIONS, 
      :NEW.NEW_NUMOFHRS_WORKD_60PRORATION, 
  :NEW.NEW_NUMOFHRS_WORKD_80PRORATION, 
  :NEW.NEW_CREATED_BY, 
      :NEW.NEW_CREATED_ON, 
  APEX_APPLICATION.G_USER,
  SYSDATE);
  END;
  </code></pre>
  
  <p>I've searched for questions with the same issue but none of them have solved my problem. I've also checked for spelling mistakes and I'm sure that the spelling is correct. </p>