title: Exception - Oracle to Db2
body: <p>Good afternoon</p>
  
  <p>Oracle for DB2 procedures and I can't run on Exception:</p>
  
  <pre><code>Create or replace PROCEDURE SP_NOST
      BEGIN
          UPDATE DMTLDBR.TB_FATO_VALOR_NOST
             SET REG_VALREAL_CLTE = 'Other Customers'
           WHERE REG_VALREAL_CLTE = '-1';
  
          COMMIT ;  
  
      EXCEPTION 
  
          WHEN OTHERS THEN
               RAISE_APPLICATION_ERROR(-20000, 'Erro : SP_NOST - UPDATE -1 : '|| SQLERRM );
      END ;
  END
  </code></pre>
  
  <p>The error that appears is;</p>
  
  <pre><code>[Code: -104, SQL State: 42601]  An unexpected token "EXCEPTION" was found following "COMMIT ".  Expected tokens may include:  "  
  
  ".. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.25.1301
  </code></pre>
  
  <p>Can anyone help me ???</p>