Compiling a PL/SQL Program with Debug Information

You can compile a PL/SQL program so that it does or does not provide debug information in the results. Oracle PL/SQL Debugger cannot debug programs without this debug information.

Compiling with Debug Information

There are two compile commands: Compile and Compile Debug. Both commands compile the PL/SQL program in the database, except that the Compile Debug command provides debug information in its compilation.

Note:

If the Compile Debug command is executed, but the user does not have the proper debug privileges, then compile will fail and the program cannot be debugged.

To compile a PL/SQL program, do one of the following:

  • From Server Explorer, expand the node that contains the program being compiled, right-click on that program, and from the menu, select Compile or Compile Debug.

  • From a program source window, right-click, and from the menu, select Compile or Compile Debug.

Note:

Oracle Developer Tools only compiles the top-level PL/SQL program.

Note:

You cannot compile during debugging. Some menus are disabled (greyed out) to reflect this.

Note:

Compiler Settings affecting Compile and Compile Debug operations may be modified through the PL/SQL Compiler Settings Options Page. For more information see PL/SQL Compiler Settings Options Page.

See Also

About Server Explorer

Viewing Compile Debug Property Information

There are several ways that you can view property information for the Compile Debug option to verify whether a program has been compiled with or without debug information. This is typically needed when debugging has been completed, and it is necessary to recompile normally any unit that was previously compiled with debug information.

Server Explorer uses distinct debug icons to indicate at a glance whether or not the program is compiled with debug information.

For example, to view the icons, expand the Procedures node from Server Explorer. The icons appear before the names of the node. Any program unit that been compiled for debug is identified by a distinct icon.

To view the Compile Debug Option property, expand the Procedures node from Server Explorer, right-click on the PL/SQL program, and from the menu, select Properties. The Properties list appears.