Can I run one utPLSQL test without running the whole package?

Yes. Expand a package in Test Explorer and run an individual suite item, a selected group, or the entire package.

Where do test failures and coverage appear?

Test status appears in VS Code's Testing view. Open a result to inspect failure details; use Run with coverage to see the supported coverage results in the editor.

Do I need to install utPLSQL separately?

The database must have an accessible utPLSQL installation. Nexo can check availability and offers setup or installation actions when your Oracle account has the necessary privileges.

Can I debug a utPLSQL test in VS Code?

Yes. Choose the Debug run profile for a discovered test or package to start the integrated PL/SQL debug workflow.

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.

Oracle unit testing · Pro

Run Oracle utPLSQL tests inside VS Code

Connect to Oracle and use the VS Code Test Explorer to discover utPLSQL package suites and individual tests. Run a selection or a complete package, review pass and failure results, inspect coverage, or debug a test without switching tools.

The integrated utPLSQL test workflow is available with Pro. Your Oracle connection must be able to access an installed utPLSQL framework; Nexo also provides setup and installation actions where your database permissions allow them. · Oracle-specific

Install for free View all features

Bring the Oracle test cycle into your editor

Discover tests in VS Code

Browse connections, schemas, test packages, and suite items in the native Test Explorer, then run only the tests you want or the full package.

Review results, coverage, and failures

See pass and fail status in the testing view, inspect failure details, run with coverage, and launch a test in the debugger.

From an Oracle connection to test results

Nexo connects the database test framework to VS Code's built-in testing actions and result views.

Connect to Oracle

Open your Oracle connection and make sure utPLSQL is installed and visible to the account. Use the extension's setup actions if the framework needs attention.

Discover package tests

Open the VS Code Testing view, refresh discovery if needed, and expand the connection, schema, and package to see its available suite items.

Run, inspect, or debug

Run a single test or package, choose Run with coverage, or start Debug from Test Explorer. Review outcomes and failure details in VS Code.

FAQ

utPLSQL testing 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

PL/SQL Debugger

Step through Oracle code in VS Code with breakpoints, variable inspection, watches, and a live call stack.

Explore feature

utPLSQL Unit Testing

Install for free

Supported databases

Oracle Database

Service names, SIDs, TNS and wallets, plus PL/SQL, debugging and APEX/ORDS tooling.

Connection guide

PostgreSQL

Connect to PostgreSQL or Supabase, browse schemas and run SQL worksheets.

Connection guide

MySQL

A dedicated MySQL adapter for connections, SQL worksheets and query results.

Connection guide

MariaDB

A dedicated MariaDB adapter, separate from MySQL, with SQL worksheets and results.

Connection guide

SQLite

Open a local database file, with no server or port, and query it from VS Code.

Connection guide

Microsoft SQL Server

Connect with SQL logins and encryption settings, then run T-SQL worksheets.

Connection guide

Feature availability