Developing
- Developing and Debugging PL/SQL using SQL Developer
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/prod/appdev/sqldev/plsql_debug/plsql_debug_otn.htm
This tutorial shows you how to create, run, and debug a PL/SQL procedure using Oracle SQL Developer.