title: Commit or handle rollback in stored procedure after insertions are done?
body: <p>Optimal way to handle an error in stored procedure that only makes inserts?</p>
  
  <p>I have a procedure like this:</p>
  
  <pre><code>PROCEDURE INSERT_TO_TABLES (VAL1 IN NUMBER, VAL2 IN NUMBER, RESULT OUT NUMBER)
  IS
  BEGIN
      INSERT INTO TABLE_1 (A_COLUMN) VALUES (VAL1);
      INSERT INTO TABLE_2 (B_COLUMN) VALUES (VAL2);
      COMMIT;
  END;
  </code></pre>
  
  <p>How could I make this stored procedure optimal enough to handle a rollback and raise an exception to catch from the application (C# try/catch) if only 1 of those inserts throws an error? Return out value true if everything is ok or false if an error happened?</p>