title: Is there a way to terminate the insert query in a trigger?
body: <p>I wonder is it able to terminate or stop the Insert if it hits the exceptions.</p>
  <p>The trigger coding will be:</p>
  <pre><code>CREATE OR REPLACE TRIGGER TRG_UPT_SOLVED_RPT
  AFTER INSERT ON Payment
  FOR EACH ROW
  
  DECLARE
  more_one_row EXCEPTION;
  v_rowCount number;
  
  BEGIN
      SELECT TCOUNT(ReportID) INTO v_rowCount
      FROM Report;
  
      IF v_rowCount &lt;= 1 THEN
          **Do anything else**
      ELSIF v_rowCount &gt; 0 THEN
          RAISE more_one_row;
      END IF;
  
      EXCEPTION
          WHEN NO_DATA_FOUND THEN
              DBMS_OUTPUT.PUT_LINE('Update table failed. Row to be update is not found.');
          WHEN more_one_row THEN
              DBMS_OUTPUT.PUT_LINE('Update table failed. Row to be update is more than one.');
  END;
  /
  </code></pre>