title: Disable auto-commit for execution procedures on PL/SQL Developer
body: <p>I'm currently using PL/SQL Developer to run some queries at my job, and my colleague uses TOAD to run the EXECs for procedures, since TOAD does not autocommit them. So, whenever I need to run a procedure, I must send him the codes and wait for him response.</p>
  
  <p>Is there a way to stop PL/SQL Developer from autocommiting them?</p>
  
  <p>I've already looked in the preferences and couldn't find any option to stop this from happening. The option "autocommit after Execute" is disabled, as well as all other autocommit functions I could find.</p>
  
  <p>I'm running the procedures using</p>
  
  <pre><code>    Begin
         PROCEDURE
      End
  </code></pre>
  
  <p>since neither EXEC or EXECUTE seem to work</p>
  
  <p>Here's the code I'm supposed to run (and works perfectly with TOAD)</p>
  
  <pre><code>    exec PWSYS.MAINT.MOVE_INCIDENT('here goes some data','here goes more data');
  </code></pre>
  
  <p>It doesn't run with EXEC on PL/SQL Developer (it displays error ORA-00900: invalid SQL statement), so I tried this</p>
  
  <pre><code>    Begin
         PWSYS.MAINT.MOVE_INCIDENT('data here','data here as well');
      End
  </code></pre>
  
  <p>It runs perfectly, but it also autocommits, and THAT'S my problem.</p>
  
  <p>So, in summary, I need a way to stop it from autocommiting, or a way to rollback the data I've inserted/changed.</p>
  
  <p>Thanks in advance</p>