Can I debug Oracle packages in VS Code?

Yes. Start a debug session for supported PL/SQL packages, procedures, or functions from Connections Explorer or the active editor.

Can I see variable values at each step?

When execution pauses, inspect the variables Oracle exposes for the current frame, add watch expressions, and review the call stack and output as you step through the code.

What does Oracle need for debugging?

The connected Oracle account needs the required debugging privileges, and the database connection must be able to use Oracle JDWP. Compile the target for debugging when required.

Do all features work with every database?

Database support does not imply identical features. Connections and SQL worksheets are the starting point; editing, DDL, modeling, transfers, administration and AI operations depend on the engine and workflow. Check the installed version and the relevant guide before relying on an advanced operation.

PL/SQL debugger · Pro

Step through Oracle PL/SQL with a VS Code debugger

Debug Oracle packages, procedures, and functions without leaving VS Code. Start a PL/SQL debug session from Connections Explorer or the editor, pause at breakpoints, step over, into, or out of code, and inspect variable values, watches, the call stack, and output as execution proceeds.

Interactive PL/SQL debugging is available with Pro. The Oracle connection must have the required debug privileges and access for Oracle JDWP debugging. · Oracle-specific

Install for free View all features

See what PL/SQL is doing while it runs

Control execution one step at a time

Set breakpoints in Oracle source and use VS Code's debugger controls to continue, step over, step into, or step out of the current code.

Inspect live execution state

Check available variable values, add watch expressions, follow the call stack, and read debugger output while execution is paused.

From Oracle source to a live debug session

Use the object or editor actions to prepare the target, then work through the session with the familiar VS Code Debug view.

Choose a PL/SQL target

Open a package, procedure, or function from Connections Explorer, or open its source in the editor and use the Debug action.

Compile with debug information

If needed, use Compile for debugging from the Oracle object actions so the target can be inspected during execution.

Set breakpoints and step

Start debugging, pause at a breakpoint, then step through the code while inspecting variables, watches, the call stack, and output.

FAQ

Oracle PL/SQL debugging questions

Explore Nexo

Focused tools for everyday database development

See how each Nexo SQL Studio feature fits into your database workflow in VS Code.

Nexo AI for Oracle APEX in Chrome

Connect APEX to VS Code: autocomplete, formatting, external editing and AI changes with live reload.

Explore feature

Visual SQL Query Builder

Compose Oracle SELECT statements visually and continue with editable SQL in a worksheet.

Explore feature

PL/SQL IntelliSense

Get context-aware Oracle completions online and across local PL/SQL projects.

Explore feature

AI-Assisted Development

Use database context for SQL, PL/SQL, debugging, optimization, and modeling workflows.

Explore feature

MCP for Oracle Workflows

Connect compatible AI tools to approved database context and operations with granular controls.

Explore feature

SQL and PL/SQL Formatter

Keep Oracle SQL and PL/SQL readable and consistent inside the VS Code editor.

Explore feature

Visual Data Modeler

Design and maintain data models as workspace files with visual and AI-compatible workflows.

Explore feature

Offline PL/SQL Workspace

Generate local Oracle definitions and keep coding with PL/SQL IntelliSense, navigation, and autocomplete without a live database.

Explore feature

utPLSQL Unit Testing

Discover Oracle test suites and run individual tests or whole packages from VS Code Test Explorer, with results, coverage, and debugging.

Explore feature

PL/SQL Debugger

Interactive PL/SQL debugging is available with Pro. The Oracle connection must have the required debug privileges and access for Oracle JDWP debugging. · Oracle-specific

Install for free