title: Difference between COMPILE and COMPILE WITH DEBUG within Oracle Sql Dev?
body: <p>I am new to Oracle SQL developer and I was just curious as to the difference between the COMPILE and COMPILE WITH DEBUG options.  Does this mean if a program unit is simply COMPILED, then I will not be able to debug it ? </p>
  
  <p>What about in a production environment, where I want to run through the procedure (in debug mode) but without recompiling (in order to avoid invalidating other objects) ?</p>