Debug PL/SQL

ALTER SESSION SET PLSQL_DEBUG=TRUE

SQL> GRANT EXECUTE ON DBMS_DEBUG to dbo;

SQL> GRANT EXECUTE ON DBMS_DEBUG_JDWP to dbo;


Grant succeeded.

SQL> Grant debug any procedure to dbo;

Grant succeeded.

SQL> Grant debug connect session to dbo;

Grant succeeded.

SQL>