utPLSQL can be installed in editioned schema.

All utPLSQL objects are now explicitly defined as non-editionable. The framework can be installed into editioned schema without issues. Resolves: #1161
utPLSQL · jgebal · Jun 7, 2026 · Jun 7, 2026 · Jun 7, 2026 · Jun 7, 2026
commit f3bfcae13396db4840acf951230586dcbed41321
diff --git a/.github/scripts/create_test_users.sh b/.github/scripts/create_test_users.sh
@@ -18,6 +18,9 @@ PROMPT Creating UT3_TESTER - Power-user for testing internal framework code
 create user UT3_TESTER identified by "ut3" default tablespace $UT3_TABLESPACE quota unlimited on $UT3_TABLESPACE;
 grant create session, create procedure, create type, create table to UT3_TESTER;
 
+# Editioning is enable on test users to validate that utPLSQL works well with editioned schema
+alter user UT3_TESTER enable editions;
+
 grant execute on dbms_lock to UT3_TESTER;
 
 PROMPT Granting $UT3_DEVELOP_SCHEMA code to UT3_TESTER
@@ -52,6 +55,9 @@ PROMPT Creating UT3_USER - minimal privileges user for API testing
 create user UT3_USER identified by "ut3" default tablespace $UT3_TABLESPACE quota unlimited on $UT3_TABLESPACE;
 grant create session, create procedure, create type, create table to UT3_USER;
 
+# Editioning is enable on test users to validate that utPLSQL works well with editioned schema
+alter user UT3_USER enable editions;
+
 PROMPT Grants for starting a debugging session from UT3_USER
 grant debug connect session to UT3_USER;
 grant debug any procedure to UT3_USER;

diff --git a/.github/scripts/install.sh b/.github/scripts/install.sh
@@ -19,3 +19,13 @@ set verify off
 alter session set plsql_optimize_level=0;
 @${INSTALL_FILE} $UT3_DEVELOP_SCHEMA $UT3_DEVELOP_SCHEMA_PASSWORD
 SQL
+
+#Enable editioning on the UT3_DEVELOP schema
+time "$SQLCLI" sys/$ORACLE_PWD@//$CONNECTION_STR AS SYSDBA <<-SQL
+whenever sqlerror exit failure rollback
+set feedback off
+set verify off
+
+alter user $UT3_DEVELOP_SCHEMA enable editions;
+exit
+SQL
diff --git a/source/api/ut.pkb b/source/api/ut.pkb
@@ -1,4 +1,4 @@
-create or replace package body ut is
+create or replace noneditionable package body ut is
 
   /*
   utPLSQL - Version 3

diff --git a/source/api/ut.pks b/source/api/ut.pks
@@ -1,4 +1,4 @@
-create or replace package ut authid current_user as
+create or replace noneditionable package ut authid current_user as
 
   /*
   utPLSQL - Version 3

diff --git a/source/api/ut_runner.pkb b/source/api/ut_runner.pkb
@@ -1,4 +1,4 @@
-create or replace package body ut_runner is
+create or replace noneditionable package body ut_runner is
 
   /*
   utPLSQL - Version 3

diff --git a/source/api/ut_runner.pks b/source/api/ut_runner.pks
@@ -1,4 +1,4 @@
-create or replace package ut_runner authid current_user is
+create or replace noneditionable package ut_runner authid current_user is
 
   /*
   utPLSQL - Version 3

diff --git a/source/api/ut_suite_item_info.tpb b/source/api/ut_suite_item_info.tpb
@@ -1,4 +1,4 @@
-create or replace type body ut_suite_item_info is
+create or replace noneditionable type body ut_suite_item_info is
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/api/ut_suite_item_info.tps b/source/api/ut_suite_item_info.tps
@@ -1,4 +1,4 @@
-create or replace type ut_suite_item_info as object (
+create or replace noneditionable type ut_suite_item_info as object (
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/api/ut_suite_items_info.tps b/source/api/ut_suite_items_info.tps
@@ -1,4 +1,4 @@
-create or replace type ut_suite_items_info as
+create or replace noneditionable type ut_suite_items_info as
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/annotations/ut_annotated_object.tps b/source/core/annotations/ut_annotated_object.tps
@@ -1,4 +1,4 @@
-create type ut_annotated_object as object(
+create or replace noneditionable type( )ut_annotated_object as object(
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/annotations/ut_annotated_objects.tps b/source/core/annotations/ut_annotated_objects.tps
@@ -1,4 +1,4 @@
-create type ut_annotated_objects as
+create or replace noneditionable type( )ut_annotated_objects as
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/annotations/ut_annotation.tps b/source/core/annotations/ut_annotation.tps
@@ -1,4 +1,4 @@
-create type ut_annotation as object(
+create or replace noneditionable type( )ut_annotation as object(
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/annotations/ut_annotation_cache_manager.pkb b/source/core/annotations/ut_annotation_cache_manager.pkb
@@ -1,4 +1,4 @@
-create or replace package body ut_annotation_cache_manager as
+create or replace noneditionable package body ut_annotation_cache_manager as
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/annotations/ut_annotation_cache_manager.pks b/source/core/annotations/ut_annotation_cache_manager.pks
@@ -1,4 +1,4 @@
-create or replace package ut_annotation_cache_manager authid definer as
+create or replace noneditionable package ut_annotation_cache_manager authid definer as
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/annotations/ut_annotation_manager.pkb b/source/core/annotations/ut_annotation_manager.pkb
@@ -1,4 +1,4 @@
-create or replace package body ut_annotation_manager as
+create or replace noneditionable package body ut_annotation_manager as
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/annotations/ut_annotation_manager.pks b/source/core/annotations/ut_annotation_manager.pks
@@ -1,4 +1,4 @@
-create or replace package ut_annotation_manager authid current_user as
+create or replace noneditionable package ut_annotation_manager authid current_user as
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/annotations/ut_annotation_obj_cache_info.tps b/source/core/annotations/ut_annotation_obj_cache_info.tps
@@ -1,4 +1,4 @@
-create type ut_annotation_obj_cache_info as object(
+create or replace noneditionable type( )ut_annotation_obj_cache_info as object(
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/annotations/ut_annotation_objs_cache_info.tps b/source/core/annotations/ut_annotation_objs_cache_info.tps
@@ -1,4 +1,4 @@
-create type ut_annotation_objs_cache_info as
+create or replace noneditionable type( )ut_annotation_objs_cache_info as
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/annotations/ut_annotation_parser.pkb b/source/core/annotations/ut_annotation_parser.pkb
@@ -1,4 +1,4 @@
-create or replace package body ut_annotation_parser as
+create or replace noneditionable package body ut_annotation_parser as
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/annotations/ut_annotation_parser.pks b/source/core/annotations/ut_annotation_parser.pks
@@ -1,4 +1,4 @@
-create or replace package ut_annotation_parser authid current_user as
+create or replace noneditionable package ut_annotation_parser authid current_user as
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/annotations/ut_annotations.tps b/source/core/annotations/ut_annotations.tps
@@ -1,4 +1,4 @@
-create type ut_annotations
+create or replace noneditionable type( )ut_annotations
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/annotations/ut_trigger_check.pkb b/source/core/annotations/ut_trigger_check.pkb
@@ -1,4 +1,4 @@
-create or replace package body ut_trigger_check is
+create or replace noneditionable package body ut_trigger_check is
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/annotations/ut_trigger_check.pks b/source/core/annotations/ut_trigger_check.pks
@@ -1,4 +1,4 @@
-create or replace package ut_trigger_check authid definer is
+create or replace noneditionable package ut_trigger_check authid definer is
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/coverage/ut_coverage.pkb b/source/core/coverage/ut_coverage.pkb
@@ -1,4 +1,4 @@
-create or replace package body ut_coverage is
+create or replace noneditionable package body ut_coverage is
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/coverage/ut_coverage.pks b/source/core/coverage/ut_coverage.pks
@@ -1,4 +1,4 @@
-create or replace package ut_coverage authid current_user is
+create or replace noneditionable package ut_coverage authid current_user is
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/coverage/ut_coverage_block.pkb b/source/core/coverage/ut_coverage_block.pkb
@@ -1,4 +1,4 @@
-create or replace package body ut_coverage_block is
+create or replace noneditionable package body ut_coverage_block is
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/coverage/ut_coverage_block.pks b/source/core/coverage/ut_coverage_block.pks
@@ -1,4 +1,4 @@
-create or replace package ut_coverage_block authid current_user is
+create or replace noneditionable package ut_coverage_block authid current_user is
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/coverage/ut_coverage_helper.pkb b/source/core/coverage/ut_coverage_helper.pkb
@@ -1,4 +1,4 @@
-create or replace package body ut_coverage_helper is
+create or replace noneditionable package body ut_coverage_helper is
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/coverage/ut_coverage_helper.pks b/source/core/coverage/ut_coverage_helper.pks
@@ -1,4 +1,4 @@
-create or replace package ut_coverage_helper authid definer is
+create or replace noneditionable package ut_coverage_helper authid definer is
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/coverage/ut_coverage_helper_block.pkb b/source/core/coverage/ut_coverage_helper_block.pkb
@@ -1,4 +1,4 @@
-create or replace package body ut_coverage_helper_block is
+create or replace noneditionable package body ut_coverage_helper_block is
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/coverage/ut_coverage_helper_block.pks b/source/core/coverage/ut_coverage_helper_block.pks
@@ -1,4 +1,4 @@
-create or replace package ut_coverage_helper_block authid current_user is
+create or replace noneditionable package ut_coverage_helper_block authid current_user is
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/coverage/ut_coverage_helper_profiler.pkb b/source/core/coverage/ut_coverage_helper_profiler.pkb
@@ -1,4 +1,4 @@
-create or replace package body ut_coverage_helper_profiler is
+create or replace noneditionable package body ut_coverage_helper_profiler is
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/coverage/ut_coverage_helper_profiler.pks b/source/core/coverage/ut_coverage_helper_profiler.pks
@@ -1,4 +1,4 @@
-create or replace package ut_coverage_helper_profiler authid definer is
+create or replace noneditionable package ut_coverage_helper_profiler authid definer is
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/coverage/ut_coverage_profiler.pkb b/source/core/coverage/ut_coverage_profiler.pkb
@@ -1,4 +1,4 @@
-create or replace package body ut_coverage_profiler is
+create or replace noneditionable package body ut_coverage_profiler is
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/coverage/ut_coverage_profiler.pks b/source/core/coverage/ut_coverage_profiler.pks
@@ -1,4 +1,4 @@
-create or replace package ut_coverage_profiler authid current_user is
+create or replace noneditionable package ut_coverage_profiler authid current_user is
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/coverage/ut_coverage_reporter_base.tpb b/source/core/coverage/ut_coverage_reporter_base.tpb
@@ -1,4 +1,4 @@
-create or replace type body ut_coverage_reporter_base is
+create or replace noneditionable type body ut_coverage_reporter_base is
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/coverage/ut_coverage_reporter_base.tps b/source/core/coverage/ut_coverage_reporter_base.tps
@@ -1,4 +1,4 @@
-create or replace type ut_coverage_reporter_base under ut_output_reporter_base(
+create or replace noneditionable type ut_coverage_reporter_base under ut_output_reporter_base(
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/events/ut_event_item.tps b/source/core/events/ut_event_item.tps
@@ -1,4 +1,4 @@
-create or replace type ut_event_item authid current_user as object (
+create or replace noneditionable type ut_event_item authid current_user as object (
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/events/ut_event_listener.tps b/source/core/events/ut_event_listener.tps
@@ -1,4 +1,4 @@
-create or replace type ut_event_listener authid current_user as object (
+create or replace noneditionable type ut_event_listener authid current_user as object (
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/events/ut_event_manager.pkb b/source/core/events/ut_event_manager.pkb
@@ -1,4 +1,4 @@
-create or replace package body ut_event_manager  as
+create or replace noneditionable package body ut_event_manager  as
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/events/ut_event_manager.pks b/source/core/events/ut_event_manager.pks
@@ -1,4 +1,4 @@
-create or replace package ut_event_manager authid current_user as
+create or replace noneditionable package ut_event_manager authid current_user as
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/output_buffers/ut_output_buffer_base.tpb b/source/core/output_buffers/ut_output_buffer_base.tpb
@@ -1,4 +1,4 @@
-create or replace type body ut_output_buffer_base is
+create or replace noneditionable type body ut_output_buffer_base is
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/output_buffers/ut_output_buffer_base.tps b/source/core/output_buffers/ut_output_buffer_base.tps
@@ -1,4 +1,4 @@
-create or replace type ut_output_buffer_base force authid definer as object(
+create or replace noneditionable type ut_output_buffer_base force authid definer as object(
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/output_buffers/ut_output_bulk_buffer.tpb b/source/core/output_buffers/ut_output_bulk_buffer.tpb
@@ -1,4 +1,4 @@
-create or replace type body ut_output_bulk_buffer is
+create or replace noneditionable type body ut_output_bulk_buffer is
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/output_buffers/ut_output_bulk_buffer.tps b/source/core/output_buffers/ut_output_bulk_buffer.tps
@@ -1,4 +1,4 @@
-create or replace type ut_output_bulk_buffer under ut_output_buffer_base (
+create or replace noneditionable type ut_output_bulk_buffer under ut_output_buffer_base (
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/output_buffers/ut_output_clob_table_buffer.tpb b/source/core/output_buffers/ut_output_clob_table_buffer.tpb
@@ -1,4 +1,4 @@
-create or replace type body ut_output_clob_table_buffer is
+create or replace noneditionable type body ut_output_clob_table_buffer is
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/output_buffers/ut_output_clob_table_buffer.tps b/source/core/output_buffers/ut_output_clob_table_buffer.tps
@@ -1,4 +1,4 @@
-create or replace type ut_output_clob_table_buffer under ut_output_buffer_base (
+create or replace noneditionable type ut_output_clob_table_buffer under ut_output_buffer_base (
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/output_buffers/ut_output_data_row.tps b/source/core/output_buffers/ut_output_data_row.tps
@@ -1,4 +1,4 @@
-create or replace type ut_output_data_row as object (
+create or replace noneditionable type ut_output_data_row as object (
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/output_buffers/ut_output_data_rows.tps b/source/core/output_buffers/ut_output_data_rows.tps
@@ -1,4 +1,4 @@
-create or replace type ut_output_data_rows as
+create or replace noneditionable type ut_output_data_rows as
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/output_buffers/ut_output_table_buffer.tpb b/source/core/output_buffers/ut_output_table_buffer.tpb
@@ -1,4 +1,4 @@
-create or replace type body ut_output_table_buffer is
+create or replace noneditionable type body ut_output_table_buffer is
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/output_buffers/ut_output_table_buffer.tps b/source/core/output_buffers/ut_output_table_buffer.tps
@@ -1,4 +1,4 @@
-create or replace type ut_output_table_buffer under ut_output_buffer_base (
+create or replace noneditionable type ut_output_table_buffer under ut_output_buffer_base (
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/session_context/ut_session_context.pkb b/source/core/session_context/ut_session_context.pkb
@@ -1,4 +1,4 @@
-create or replace package body ut_session_context as
+create or replace noneditionable package body ut_session_context as
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/session_context/ut_session_context.pks b/source/core/session_context/ut_session_context.pks
@@ -1,4 +1,4 @@
-create or replace package ut_session_context as
+create or replace noneditionable package ut_session_context as
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/session_context/ut_session_info.tpb b/source/core/session_context/ut_session_info.tpb
@@ -1,4 +1,4 @@
-create or replace type body ut_session_info as
+create or replace noneditionable type body ut_session_info as
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/session_context/ut_session_info.tps b/source/core/session_context/ut_session_info.tps
@@ -1,4 +1,4 @@
-create or replace type ut_session_info under ut_event_listener (
+create or replace noneditionable type ut_session_info under ut_event_listener (
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/types/ut_console_reporter_base.tpb b/source/core/types/ut_console_reporter_base.tpb
@@ -1,4 +1,4 @@
-create or replace type body ut_console_reporter_base is
+create or replace noneditionable type body ut_console_reporter_base is
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/types/ut_console_reporter_base.tps b/source/core/types/ut_console_reporter_base.tps
@@ -1,4 +1,4 @@
-create or replace type ut_console_reporter_base under ut_output_reporter_base(
+create or replace noneditionable type ut_console_reporter_base under ut_output_reporter_base(
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/types/ut_coverage_options.tpb b/source/core/types/ut_coverage_options.tpb
@@ -1,4 +1,4 @@
-create or replace type body ut_coverage_options as
+create or replace noneditionable type body ut_coverage_options as
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/types/ut_coverage_options.tps b/source/core/types/ut_coverage_options.tps
@@ -1,4 +1,4 @@
-create or replace type ut_coverage_options force as object (
+create or replace noneditionable type ut_coverage_options force as object (
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/types/ut_executable.tpb b/source/core/types/ut_executable.tpb
@@ -1,4 +1,4 @@
-create or replace type body ut_executable is
+create or replace noneditionable type body ut_executable is
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/types/ut_executable.tps b/source/core/types/ut_executable.tps
@@ -1,4 +1,4 @@
-create or replace type ut_executable under ut_event_item(
+create or replace noneditionable type ut_executable under ut_event_item(
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/types/ut_executable_test.tpb b/source/core/types/ut_executable_test.tpb
@@ -1,4 +1,4 @@
-create or replace type body ut_executable_test as
+create or replace noneditionable type body ut_executable_test as
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project

diff --git a/source/core/types/ut_executable_test.tps b/source/core/types/ut_executable_test.tps
@@ -1,4 +1,4 @@
-create or replace type ut_executable_test authid current_user under ut_executable (
+create or replace noneditionable type ut_executable_test authid current_user under ut_executable (
   /*
   utPLSQL - Version 3
   Copyright 2016 - 2026 utPLSQL Project