Release notes from utPLSQL

v.3.2.3

2026-07-10T06:25:10Z

What's Changed

Fix issue with UT_TAP_REPORTER on Oracle 23.26 by @jgebal in #1359
Fixed support for camelCase in context --%name annotation. by @jgebal in #1361
utPLSQL can be installed in editioned schema. by @jgebal in #1362
Removed coveralls reporter by @jgebal in #1363
Clarify behavior of before/after procedures in suitepath by @jgebal in #1364
throws can reference exception without schema or package name by @jgebal in #1365
throws works with uninitialized exception variables by @jgebal in #1366

Full Changelog: v3.2.2...v.3.2.3

v3.2.2

2026-05-24T07:49:30Z

What's Changed

Filtering by tags fixed for schemas containing suite-paths and contexts by @jgebal in #1325
Fixed issue with reporter failing to initialize by @jgebal in #1354
Fixed issue with duplicate sources from dba_source by @jgebal in #1355
Allow HTML coverage on FIPS-enabled DB by @jgebal in #1356

Full Changelog: v3.2.01...v3.2.2

v3.2.01

2026-04-22T11:33:09Z

Important

Dropped support for Oracle Database versions older than 19c

New features

Add TAP reporter by @WayneNani in #1305

Enhancements and bug fixes

Added duplicate detection on cursor comparison using join_by by @lwasylow in #1295
Fix code causing the object duration Oracle exception on oracle 23.26 by @lwasylow in #1310
Packages with annotation-like comments are not test suites by @jgebal in #1313
Performance improvements to annotation parsing by @lwasylow in #1312
Updated documentation and copyright banners across source files @jgebal in #1319

New Contributors

@bozo030 made their first contribution in #1276
@WayneNani made their first contribution in #1305

Full Changelog: v3.1.14...v3.2.01

v3.1.14

2024-02-19T21:45:23Z

What's Changed

Added support for and and or operators when running tests by tags by @lwasylow in #1250
Allow for test runs over 4 hours by @jgebal in #1243
Framework performance improvements by @jgebal in #1249
Support multiple expectation failures with teamcity reporter by @jgebal in #1251
Address issue where the not_to(contain) not run correctly by @lwasylow in #1246
Fix regex to be NLS_SORT independent by @jgebal in #1253
Fix output length error and output buffer. by @jgebal in #1255
(docs): Update running-unit-tests.md - remove example by @gassenmj in #1261
The line-rate is not recorded for packages and classes in cobertura coverage reporter by @lwasylow in #1269
(docs): Fix nested list issue by @iamrachid in #1274
Update TFS reporter to correct format by @lwasylow in #1270

New Contributors

@gassenmj made their first contribution in #1261
@iamrachid made their first contribution in #1274

Full Changelog: v3.1.13...v3.1.14

v3.1.13

2023-05-27T11:39:27Z

Changes in release 3.1.13

New features

Add ability to run tests by part of a name. Fixed in #1203, resolves #470

Enhancements

Added documentation section on creating a custom reporter. Fixed in #1225, resolves #710
Add ability to specify code coverage objects include/exclude masks as regular expressions. Fixed in #1186, resolves #1053

Bug fixes

Comparing collection that have long type names. Fixed in #1238, resolves #1235.
Code coverage reporting on code with long lines. Fixed in #1240, resolves #1232, #1087.
Code coverage reporting does not exclude tests. Fixed in #1226, resolves #1222.
Uninstall script buffer overflow. Fixed in #1221, resolves #1220.

Internal improvements

Improved process of generating utPLSQL documentation. Implemented in 689bbd0, resolves #1237.
Removed username env variables for internal development. Implemented in #1201, resolves #1200.
Test execution data of utPLSQL project not showing on SonarCloud. Implemented in #1199, resolves #1198.

v3.1.12

2022-02-25T00:49:32Z

Changes in release 3.1.12

New features

Added support for description in the --%disabled annotation. See documentation. Implemented in: #1183, resolves #610.
Added support for native JSON datatype on Oracle 21c. Implemented in #1181, resolves #1114.
Added new mather to_be_within( distance|pct ).of_(expoected). See documentation. Implemented in #1076, resolves #77.

Enhancements

Improved performance of SQL used to retrieve Coverage sources. Implemented in #1187, resolves #1169.
Added ability for utPLSQL to gather coverage on code invoking DBMS_STATS package. Implemented in #1184, resolves #1097, #1094.
Fixed typos and improved documentation. Implemented in #1173, #1171

Bug fixes

Actual and Expected are now correctly reported when comparing JSON data. Implemented in #1181, resolves #1113.
Packages with removed annotations are now correctly recognized as non-utPLSQL packages. Implemented in #1180, resolves #1177.
Fixed issues with comparison of nested object structures. Implemented in #1179, resolves #1082, #1083, #1098.

Internal improvements

Moved build and test process for utPLSQL from Travis to GithubActions. Implemented in #1175

utPLSQL v3.1.11

2021-11-17T23:27:46Z

Changes in release 3.1.11

Enhancements

utPLSQL can now be used to generate coverage reports for external tools. See documentation
Implemented in: #1079, resolves #1025
Enhanced UT_COVERAGE_COBERTURA_REPORTER to better support TFS and GitLab. Implemented in #1137 and #1140, resolves #1107
Added support for installation on Oracle 21c - removed dependency on DBMS_OBFUSCATION_TOOLKIT. Implemented in #1112, resolves #1111 and #1127
Added support for running utPLSQL framework in parallel-enabled database. Implemented in #1160, resolves #1134

Bug fixes

Suite structure is built properly even with other than English TNS settings. Implemented in #1061, resolves #1060
Fixed XML content reporting (CDATA) in UT_REALTIME_REPORTER used by SQLDeveloper plugin. Implemented in #1075, resolves #1073
Fixed XML content reporting (CDATA) in JUnit reporter - regression. Implemented in #1085, resolves #1084
Fixed issue with utPLSQL failing to run coverage reporting when trigger has overlapping name with procedure/function/package/type. Implemented in #1091, resolves #1086
Fixed issue with parsing utPLSQL suites with DDL trigger when usign AUTHID clause. Implemented in #1093, resolves #1088

Internal improvements

Improved how privilege checks are handled by framework installation. Implemented in #1056, resolves #1050
Restructured installation instructions to make it more readable. Implemented in #1063, resolves #1062
Updated database requirements in documentation. Implemented in #1065, resolves #1064
Removed duplicated call to install profiler tables. Implemented in #1164, resolves #1149
Fixed failing internal framework tests on Oracle 21c. Implemented in #1158, resolves #1151
Fixed confusing typo in documentation. Resolves #1154
Moved build process from travis-ci.org to travis-ci.com. Implemented in #1152
Added an example of reporter reporting all expectations, not only the failing ones. Implemented in #1092

utPLSQL v3.1.10

2020-02-23T16:38:29Z

Changes in release 3.1.10

Enhancements

utPLSQL test runner is now validating arguments of --%throws annotations at runtime #721 #1033
Documented limitations of insignificant spaces comparison in compound data #880
utPLSQL will now detect empty annotation cache for schema even with DLL trigger enabled #975
Order of procedures and annotation now determines default order of tests in suite #1036

Bug fixes

Nested contexts are now properly identified #1034
TeamCity test reporter is now including error message #1045

Internal improvements

All self-tests for utPLSQL framework can now be executed using test-owner schema #969
Misleading rollback warning is no longer showing when running self-tests for utPLSQL #982

utPLSQL v3.1.9

2019-11-10T11:51:35Z

Changes in release 3.1.9

New features

Added ability to define nested contexts within test suite #938
Added ability to exclude tests/suites by tags when invoking a test-run #1007 #983
Added new annotation --%name to allow for providing custom name for contexts #1016

Important changes

The value of --%context annotation is no longer representing context name.
This value is now context description (displayname).
With this change, the --%context annotation is now aligned with --%test and --%suite annotation syntax.

New annotation --%name was introduced to facilitate naming of contexts.

Enhancements

Improved documentation for running tests
Improved documentation for tags #1003
Improved documentation for annotations

Bug fixes

Fixed bug with bad stacktrace showing in failing/erroring test #1000
Fixed issue with lack of validation for context name #966
Fixed problem with install script privilege check for installation with DDL trigger #992
Fixed issue with some common column names causing cursor comparison to fail #997
Fixed issue with invocation of standalone expectations on cursor #998

Internal improvements

Fixed runability of utplsql self-tests #968

utPLSQL v3.1.8

2019-09-04T00:00:23Z

Changes in release 3.1.8

New features

Added support for session context to provide test and suite information during test run #963 #781
Added ability to invoke expectations without running framework #956 #963
Failing expectations are now reported with call stack #967 #963

Enhancements

Improved framework table private data protection #922 #954
Improved install process. It is now unified for installation with both public and private synonyms #957 #954
Improved reporting of warnings for integration with SQLDeveloper #964
Improved query to retrieve coverage sources #981 #970
Improved security around malicious utPLSQL owner name #920

Bug fixes

Fixed cursor comparison on Oracle 11.2 #947
Fixed issue with retrieving suite data #977 #974 #978
Application context is now reset in session after test run #951