You can use JDeveloper for debugging PL/SQL procedures.