Sometimes you need compile your procedure to undestand or to see a strange behaviour.
In this case.
- Compile the procedure for Debug from your Procedure file.
- Press Debug button.
Maybe you need grants.In that case:
- grant debug connect session to hr;
- grant debug any procedure to hr;
- grant execute on DBMS_DEBUG_JDWP to hr;