"Add debug information when compiling"

[RobertK]

Marco (or anyone very familiar with this feature)

please tell me exactly what this option ADDS TO THE CODE that's actually compiled on Oracle. thanks

 

[Marco van der Linden]

You can find more information on dbms_debug here , although it does not state what is actually added to the code.

 

[RobertK]

I simply want to know what EXACTLY PSD does (at compile time) when this option is checked ---
add stuff to user code or does a triple-somersault or whatever.

 

[Marco Kalter]

It executes the following for your session:

alter session set plsql_debug=true;

As a result, when you compile your PL/SQL Program units, Oracle adds symbol information to the resulting object. This way you can view and set variables during a debug session, when stepping through the object.