title: SQL Error: ORA-38104: Columns referenced in the ON Clause cannot be updated
body: <pre><code>MERGE /*+ GATHER_PLAN_STATISTICS*/
       INTO ATM_REQUEST ATM
      USING ATM_STATUS_VIEW ST
         ON (    ATM.accountno = ST.accountno
             AND atm.status IS NULL
             AND atm.remarks IS NULL)
  WHEN MATCHED
  THEN
     UPDATE SET ATM.STATUS = ST.STATUS, ATM.REMARKS = ST.REMARKS;
  </code></pre>
  <p>am getting below error, can anyone help me on this.</p>
  <pre><code>Error at Command Line : 3 Column : 35
  Error report -
  SQL Error: ORA-38104: Columns referenced in the ON Clause cannot be updated: &quot;ATM&quot;.&quot;STATUS&quot;
  </code></pre>