Debug Oracle Procedure

For example,I have a procedure

 

 

begin

 

-- Call the procedure

 

jason_db_util_pkg.gather_table_stat(i_owner => :i_owner,

i_tabname=> :i_tablename,

o_exit_code => :o_exit_code);

end;

 

Then the package name is jason_db_util_pkg ,and procedure name is gather_table_stat

 

1,login PL/SQL

2,In Objects view, Package bodies--->YourProcedurePackageName(jason_db_util_pkg)---right click->

 

3,Click View Spec & Body ----a new widow will open---->right click YourProcedureName(gather_table_stat)---right click to debug-->

 

4,input parameters needed -->start debu(F9)-->