PL/SQL Debugging

Every user that create-user creates has the grants for PL/SQL debugging in VS Code SQL Developer. Debug a package with these steps:

1. Compile the package for debug.
2. Set a breakpoint.
3. Start the debugger.
4. Enter the IP address of your machine when the debugger asks for it.

Get the IP address of your machine:

# macOS
ipconfig getifaddr en0

# Linux
hostname -I | awk '{print $1}'

Tutorial

Watch this video tutorial. It shows every step of a debug session in this environment.