Hello fellow Oracle developers,
I am looking to see if there is a need for DBMS_DEBUG implementation amongst other users.
The SQL Developer extension provides debugging with the JDWP protocol, which requires an outgoing connection from the database. Our InfoSec people would not allow an outgoing connection from the database server to the developers' clients.
I have started to implement DBMS_DEBUG debugging in our utility extension, that has been made public and listed on the marketplace, however, the decision has been made to transition to local containerized development databases, which resolves our InfoSec issue.
As this is an officially deprecated protocol, my assumption is that Oracle does not intend to implement this form of debugging. If any of the Oracle people here know differently, please let me know.
I can continue to work on this in my own time, outside of work, if there is sufficient community need.
Anyone else run into a similar issue and are seeking a solution that would allow them to debug like they did in PL/SQL Developer or TOAD without requiring an outgoing connection from the database?