title: Store procedure transaction rollback
body: <p>I have a stored procedure which is making call to 2 other stored procedure by passing the arguments. Example:</p>
  
  <pre><code>abc.xxssd.MES_LOG_PKG.insert_row(p_msg_guid,p_payload_type);
  abc.xxssd.MES_PAY_PKG.insert_row(p_msg_guid,p_payload_type,p_payload);
  </code></pre>
  
  <p>both of these stored procedure do insert/update operation on 2 different tables which has parent child relation. I would like to put a rollback on procedures where if any error occurred on any procedure complete transaction should rollback and it should not enter any values into the DB.</p>
  
  <p>In short, both stored procedure should not perform any operation.</p>