Online Documentation for SQL Manager for Oracle

Debug procedures

To debug procedures as well as functions, packages, triggers, object types you may use PL/SQL Code Debugger. It provides  step-by-step debugging session.

To debug a PL/SQL object you need it to compile it with debug info.