title: What is the effect of placing the commit after DML in procedure?
body: <p>I have created a procedure in a package which is doing insert/delete in the table and after successful transaction, commit is done.</p>
  
  <p>like this:</p>
  
  <pre><code>create or replace package pac is    
  procedure pr_test(emp_id number)
  is
  begin
  -- some code
  if something then
    insert
  else
    delete
  
  commit;
  end pr_test;
  end pac ;
  </code></pre>
  
  <p>Should I make this transaction as AUTONOMOUS_TRANSACTION? What is the effect of placing the commit like this in program? </p>