DDL Trigger not working
Describe the bug
utPLSQL was installed with DDL trigger. However, when creating new tests or updating tests, the trigger does not update the annotation cache. ut.run() does not update the cache either, because the DDL trigger is installed. We have to manually run ut_runner.rebuild_annotation_cache() to make any new tests available.
Provide version info
Information about utPLSQL and Database version,
11.2.0.4.0 11.2.0 PL/SQL procedure successfully completed. UT_VERSION ------------------------------------------------------------ v3.1.10.3349 BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production PL/SQL Release 11.2.0.4.0 - Production CORE 11.2.0.4.0 Production TNS for Solaris: Version 11.2.0.4.0 - Production NLSRTL Version 11.2.0.4.0 - Production PARAMETER VALUE ------------------------------ ---------------------------------------- NLS_LANGUAGE ENGLISH NLS_TERRITORY GERMANY NLS_CURRENCY € NLS_ISO_CURRENCY GERMANY NLS_NUMERIC_CHARACTERS ,. NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD.MM.YYYY HH24:MI:SS NLS_DATE_LANGUAGE ENGLISH NLS_SORT BINARY NLS_TIME_FORMAT HH24:MI:SSXFF NLS_TIMESTAMP_FORMAT DD.MM.YYYY HH24:MI:SSXFF NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR NLS_TIMESTAMP_TZ_FORMAT DD.MM.YYYY HH24:MI:SSXFF TZR NLS_DUAL_CURRENCY € NLS_COMP BINARY NLS_LENGTH_SEMANTICS BYTE NLS_NCHAR_CONV_EXCP FALSE 17 rows selected. PORT_STRING ------------------------------------------------------------ SVR4-be-64bit-8.1.0
Information about client software
What client was used to run utPLSQL tests?
--> SQLDeveloper
To Reproduce
Steps to reproduce the behavior:
- install utPLSQL with DDL trigger
- create or modify a unit test
- run ut.run()
- notice that the new/changed tests are not present
- run ut_runner.rebuild_annotation_cache()
- run ut.run()
- notice the tests are correct now
Expected behavior
When the DDL trigger is installed and active, new test objects should automatically be recognized and part of the tests. No need to manully rebuild the cache.
Example code
select object_owner, max(parse_time) from ut3.ut_annotation_cache_info group by object_owner; OBJECT_OWNER MAX(PARSE_TIME) ------------------------------ ----------------------------- APPS 03.07.2020 12:33:09,864321000 begin if ut3.ut_trigger_check.is_alive() then dbms_output.put_line('Trigger alive'); else dbms_output.put_line('Trigger NOT alive'); end if; end; Trigger alive PL/SQL procedure successfully completed. select * from ut3.ut_annotation_cache where annotation_name = 'suite' and annotation_text = 'xxpk_ut_test'; no rows selected CREATE OR REPLACE PACKAGE apps.xxpk_ut_test AUTHID DEFINER AS -- %suite(xxpk_ut_test) -- %test(just testing) PROCEDURE t_ut_test; END xxpk_ut_test; Package XXPK_UT_TEST compiled CREATE OR REPLACE PACKAGE BODY apps.xxpk_ut_test AS PROCEDURE t_ut_test IS BEGIN NULL; END; END xxpk_ut_test; Package Body XXPK_UT_TEST compiled select * from ut3.ut_annotation_cache where annotation_name = 'suite' and annotation_text = 'xxpk_ut_test'; no rows selected select object_owner, max(parse_time) from ut3.ut_annotation_cache_info group by object_owner; OBJECT_OWNER MAX(PARSE_TIME) ------------------------------ ----------------------------- APPS 03.07.2020 12:33:09,864321000 select * from ut3.ut_annotation_cache_info where object_owner = 'APPS' and object_name = 'XXPK_UT_TEST'; no rows selected exec ut_runner.rebuild_annotation_cache('APPS'); PL/SQL procedure successfully completed. select object_owner, max(parse_time) from ut3.ut_annotation_cache_info group by object_owner; OBJECT_OWNER MAX(PARSE_TIME) ------------------------------ ----------------------------- APPS 04.07.2020 11:16:48,524991000 select * from ut3.ut_annotation_cache_info where object_owner = 'APPS' and object_name = 'XXPK_UT_TEST'; CACHE_ID OBJECT_OWNER OBJECT_NAME OBJECT_TYPE PARSE_TIME ---------- ------------------------------ ------------------------------ ------------------------------ ----------------------------- 41207 APPS XXPK_UT_TEST PACKAGE 04.07.2020 11:16:48,524991000 select * from ut3.ut_annotation_cache where annotation_name = 'suite' and annotation_text = 'xxpk_ut_test'; CACHE_ID ANNOTATION_POSITION ANNOTATION_NAME ANNOTATION_TEXT SUBOBJECT_NAME ---------- ------------------- ------------------------------ ------------------------------ ------------------------------ 41207 4 suite xxpk_ut_test
Additional context
Installation:
# install utPL/SQL if [ -f /mnt/dbpatches/utPLSQL/source/install_headless_with_trigger.sql ]; then cd /mnt/dbpatches/utPLSQL/source sqlplus "/ as sysdba" <<EOF > ~/delphix_log/install_utplsql.log @install_headless_with_trigger.sql EOF fi --------------------------------------------------------------------------- oraprod@dpx01db02$ cat install_utplsql.log SQL*Plus: Release 11.2.0.4.0 Production on Sun Jun 28 15:26:15 2020 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP and Data Mining options SQL> no rows selected Creating utPLSQL user UT3 -------------------------------------------------------------- Installing utPLSQL v3 framework into UT3 schema -------------------------------------------------------------- Switching current schema to UT3 -------------------------------------------------------------- Installing component UT_DBMS_OUTPUT_CACHE No errors. -------------------------------------------------------------- Installing component UT_VARCHAR2_LIST No errors. -------------------------------------------------------------- Installing component UT_VARCHAR2_ROWS No errors. -------------------------------------------------------------- Installing component UT_INTEGER_LIST No errors. -------------------------------------------------------------- Installing component UT_OBJECT_NAME No errors. -------------------------------------------------------------- Installing component UT_OBJECT_NAME No errors. -------------------------------------------------------------- Installing component UT_OBJECT_NAMES No errors. -------------------------------------------------------------- Installing component UT_KEY_VALUE_PAIR No errors. -------------------------------------------------------------- Installing component UT_KEY_VALUE_PAIRS No errors. -------------------------------------------------------------- Installing component UT_REPORTER_INFO No errors. -------------------------------------------------------------- Installing component UT_REPORTERS_INFO No errors. -------------------------------------------------------------- Installing component UT_UTILS No errors. -------------------------------------------------------------- Installing component UT_METADATA No errors. -------------------------------------------------------------- Installing component UT_SAVEPOINT_SEQ No errors. -------------------------------------------------------------- Installing component UT_UTILS No errors. -------------------------------------------------------------- Installing component UT_METADATA No errors. -------------------------------------------------------------- Installing component UT_ANSICONSOLE_HELPER No errors. -------------------------------------------------------------- Installing component UT_ANSICONSOLE_HELPER No errors. -------------------------------------------------------------- Installing component UT_SUITE_ITEM_INFO No errors. -------------------------------------------------------------- Installing component UT_SUITE_ITEM_INFO No errors. -------------------------------------------------------------- Installing component UT_SUITE_ITEMS_INFO No errors. -------------------------------------------------------------- Installing component UT_EVENT_ITEM No errors. -------------------------------------------------------------- Installing component UT_EVENT_LISTENER No errors. -------------------------------------------------------------- Installing component UT_EVENT_MANAGER No errors. -------------------------------------------------------------- Installing component UT_EVENT_MANAGER No errors. -------------------------------------------------------------- Installing component UT_RUN_INFO No errors. -------------------------------------------------------------- Installing component UT_RUN_INFO No errors. -------------------------------------------------------------- Installing component UT_EXPECTATION_RESULT No errors. -------------------------------------------------------------- Installing component UT_EXPECTATION_RESULTS No errors. -------------------------------------------------------------- Installing component UT_RESULTS_COUNTER No errors. -------------------------------------------------------------- Installing component UT_SUITE_ITEM No errors. -------------------------------------------------------------- Installing component UT_SUITE_ITEMS No errors. -------------------------------------------------------------- Installing component UT_EXECUTABLE No errors. -------------------------------------------------------------- Installing component UT_EXECUTABLES No errors. -------------------------------------------------------------- Installing component UT_EXECUTABLE_TEST No errors. -------------------------------------------------------------- Installing component UT_TEST No errors. -------------------------------------------------------------- Installing component UT_LOGICAL_SUITE No errors. -------------------------------------------------------------- Installing component UT_SUITE No errors. -------------------------------------------------------------- Installing component UT_SUITE_CONTEXT No errors. -------------------------------------------------------------- Installing component UT_FILE_MAPPING No errors. -------------------------------------------------------------- Installing component UT_FILE_MAPPINGS No errors. -------------------------------------------------------------- Installing component UT_COVERAGE_OPTIONS No errors. -------------------------------------------------------------- Installing component UT_RUN No errors. -------------------------------------------------------------- Installing component UT_REPORTER_BASE No errors. -------------------------------------------------------------- Installing component UT_REPORTERS No errors. -------------------------------------------------------------- Installing component JSON_OBJECTS_SPECS Installing json structures specs. No errors. -------------------------------------------------------------- Installing component UT_MATCHER_OPTIONS_ITEMS No errors. -------------------------------------------------------------- Installing component UT_MATCHER_OPTIONS No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE No errors. -------------------------------------------------------------- Installing component UT_KEY_ANYVAL_PAIR No errors. -------------------------------------------------------------- Installing component UT_KEY_ANYVAL_PAIRS No errors. -------------------------------------------------------------- Installing component UT_KEY_ANYVALUES No errors. -------------------------------------------------------------- Installing component UT_SESSION_CONTEXT No errors. -------------------------------------------------------------- Installing component UT_SESSION_CONTEXT No errors. -------------------------------------------------------------- Installing component UT_SESSION_INFO No errors. -------------------------------------------------------------- Installing component UT_SESSION_INFO No errors. -------------------------------------------------------------- Installing component UT_OUTPUT_BUFFER_INFO_TMP No errors. -------------------------------------------------------------- Installing component UT_OUTPUT_BUFFER_TMP No errors. -------------------------------------------------------------- Installing component UT_OUTPUT_CLOB_BUFFER_TMP No errors. -------------------------------------------------------------- Installing component UT_OUTPUT_DATA_ROW No errors. -------------------------------------------------------------- Installing component UT_OUTPUT_DATA_ROWS No errors. -------------------------------------------------------------- Installing component UT_OUTPUT_BUFFER_BASE No errors. -------------------------------------------------------------- Installing component UT_OUTPUT_BUFFER_BASE No errors. -------------------------------------------------------------- Installing component UT_OUTPUT_TABLE_BUFFER No errors. -------------------------------------------------------------- Installing component UT_OUTPUT_TABLE_BUFFER No errors. -------------------------------------------------------------- Installing component UT_OUTPUT_CLOB_TABLE_BUFFER No errors. -------------------------------------------------------------- Installing component UT_OUTPUT_CLOB_TABLE_BUFFER No errors. -------------------------------------------------------------- Installing component UT_OUTPUT_REPORTER_BASE No errors. -------------------------------------------------------------- Installing component UT_TRIGGER_CHECK No errors. -------------------------------------------------------------- Installing component UT_TRIGGER_CHECK No errors. -------------------------------------------------------------- Installing component UT_ANNOTATION No errors. -------------------------------------------------------------- Installing component UT_ANNOTATIONS No errors. -------------------------------------------------------------- Installing component UT_ANNOTATED_OBJECT No errors. -------------------------------------------------------------- Installing component UT_ANNOTATED_OBJECTS No errors. -------------------------------------------------------------- Installing component UT_ANNOTATION_OBJ_CACHE_INFO No errors. -------------------------------------------------------------- Installing component UT_ANNOTATION_OBJS_CACHE_INFO No errors. -------------------------------------------------------------- Installing component UT_ANNOTATION_CACHE_SEQ No errors. -------------------------------------------------------------- Installing component UT_ANNOTATION_CACHE_SCHEMA No errors. -------------------------------------------------------------- Installing component UT_ANNOTATION_CACHE_INFO No errors. -------------------------------------------------------------- Installing component UT_ANNOTATION_CACHE No errors. -------------------------------------------------------------- Installing component UT_ANNOTATION_CACHE_MANAGER No errors. -------------------------------------------------------------- Installing component UT_ANNOTATION_CACHE_MANAGER No errors. -------------------------------------------------------------- Installing component UT_ANNOTATION_PARSER No errors. -------------------------------------------------------------- Installing component UT_ANNOTATION_PARSER No errors. -------------------------------------------------------------- Installing component UT_ANNOTATION_MANAGER No errors. -------------------------------------------------------------- Installing component UT_ANNOTATION_MANAGER No errors. -------------------------------------------------------------- Installing component UT_SUITE_CACHE_ROW No errors. -------------------------------------------------------------- Installing component UT_SUITE_CACHE_ROWS No errors. -------------------------------------------------------------- Installing component UT_SUITE_CACHE_SCHEMA No errors. -------------------------------------------------------------- Installing component UT_SUITE_CACHE_PACKAGE No errors. -------------------------------------------------------------- Installing component UT_SUITE_CACHE_SEQ No errors. -------------------------------------------------------------- Installing component UT_SUITE_CACHE No errors. -------------------------------------------------------------- Installing component UT_SUITE_CACHE_MANAGER No errors. -------------------------------------------------------------- Installing component UT_SUITE_CACHE_MANAGER No errors. -------------------------------------------------------------- Installing component UT_SUITE_BUILDER No errors. -------------------------------------------------------------- Installing component UT_SUITE_BUILDER No errors. -------------------------------------------------------------- Installing component UT_SUITE_MANAGER No errors. -------------------------------------------------------------- Installing component UT_SUITE_MANAGER No errors. -------------------------------------------------------------- Installing component UT_EXPECTATION_PROCESSOR No errors. -------------------------------------------------------------- Installing component UT_EXPECTATION_PROCESSOR No errors. -------------------------------------------------------------- Installing PLSQL profiler objects into UT3 schema PLSQL_PROFILER_RUNS table created PLSQL_PROFILER_UNITS table created PLSQL_PROFILER_DATA table created Sequence PLSQL_PROFILER_RUNNUMBER created Installing PLSQL profiler objects into UT3 schema Installing DBMSPLSQL Tables objects into UT3 schema Installing component UT_FILE_MAPPER No errors. -------------------------------------------------------------- Installing component UT_FILE_MAPPER No errors. -------------------------------------------------------------- Installing component UT_COVERAGE_SOURCES_TMP No errors. -------------------------------------------------------------- Installing component UT_COVERAGE_HELPER No errors. -------------------------------------------------------------- Installing component UT_COVERAGE_HELPER_BLOCK No errors. -------------------------------------------------------------- Installing component UT_COVERAGE_HELPER_PROFILER No errors. -------------------------------------------------------------- Installing component UT_COVERAGE No errors. -------------------------------------------------------------- Installing component UT_COVERAGE_BLOCK No errors. -------------------------------------------------------------- Installing component UT_COVERAGE_PROFILER No errors. -------------------------------------------------------------- Installing component UT_COVERAGE_REPORTER_BASE No errors. -------------------------------------------------------------- Installing component UT_COVERAGE_HELPER No errors. -------------------------------------------------------------- Installing component UT_COVERAGE_HELPER_BLOCK No errors. -------------------------------------------------------------- Installing component UT_COVERAGE_HELPER_PROFILER No errors. -------------------------------------------------------------- Installing component UT_COVERAGE No errors. -------------------------------------------------------------- Installing component UT_COVERAGE_BLOCK No errors. -------------------------------------------------------------- Installing component UT_COVERAGE_PROFILER No errors. -------------------------------------------------------------- Installing component UT_COVERAGE_REPORTER_BASE No errors. -------------------------------------------------------------- Installing component UT_RESULTS_COUNTER No errors. -------------------------------------------------------------- Installing component UT_SUITE_ITEM No errors. -------------------------------------------------------------- Installing component UT_TEST No errors. -------------------------------------------------------------- Installing component UT_LOGICAL_SUITE No errors. -------------------------------------------------------------- Installing component UT_SUITE No errors. -------------------------------------------------------------- Installing component UT_SUITE_CONTEXT No errors. -------------------------------------------------------------- Installing component UT_RUN No errors. -------------------------------------------------------------- Installing component UT_EXPECTATION_RESULT No errors. -------------------------------------------------------------- Installing component UT_REPORTER_BASE No errors. -------------------------------------------------------------- Installing component UT_OUTPUT_REPORTER_BASE No errors. -------------------------------------------------------------- Installing component UT_FILE_MAPPING No errors. -------------------------------------------------------------- Installing component UT_EXECUTABLE No errors. -------------------------------------------------------------- Installing component UT_EXECUTABLE_TEST No errors. -------------------------------------------------------------- Installing component UT_CONSOLE_REPORTER_BASE No errors. -------------------------------------------------------------- Installing component UT_CONSOLE_REPORTER_BASE No errors. -------------------------------------------------------------- Installing component UT_COMPOUND_DATA_TMP No errors. -------------------------------------------------------------- Installing component UT_COMPOUND_DATA_DIFF_TMP No errors. -------------------------------------------------------------- Installing component UT_JSON_DATA_DIFF_TMP No errors. -------------------------------------------------------------- Installing component UT_COMPOUND_DATA_VALUE No errors. -------------------------------------------------------------- Installing component UT_JSON_LEAF No errors. -------------------------------------------------------------- Installing component UT_JSON_LEAF_TAB No errors. -------------------------------------------------------------- Installing component UT_JSON_TREE_DETAILS No errors. -------------------------------------------------------------- Installing component UT_CURSOR_COLUMN No errors. -------------------------------------------------------------- Installing component UT_CURSOR_COLUMN_TAB No errors. -------------------------------------------------------------- Installing component UT_CURSOR_DETAILS No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_BLOB No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_BOOLEAN No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_CLOB No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_DATE No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_DSINTERVAL No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_NUMBER No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_REFCURSOR No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_ANYDATA No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_TIMESTAMP No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_TIMESTAMP_TZ No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_TIMESTAMP_LTZ No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_VARCHAR2 No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_YMINTERVAL No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_XMLTYPE No errors. -------------------------------------------------------------- Installing component UT_COMPOUND_DATA_HELPER No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_JSON No errors. -------------------------------------------------------------- Installing component UT_MATCHER No errors. -------------------------------------------------------------- Installing component UT_COMPARISON_MATCHER No errors. -------------------------------------------------------------- Installing component UT_BE_FALSE No errors. -------------------------------------------------------------- Installing component UT_BE_GREATER_OR_EQUAL No errors. -------------------------------------------------------------- Installing component UT_BE_GREATER_THAN No errors. -------------------------------------------------------------- Installing component UT_BE_LESS_OR_EQUAL No errors. -------------------------------------------------------------- Installing component UT_BE_LESS_THAN No errors. -------------------------------------------------------------- Installing component UT_BE_LIKE No errors. -------------------------------------------------------------- Installing component UT_BE_NOT_NULL No errors. -------------------------------------------------------------- Installing component UT_BE_NULL No errors. -------------------------------------------------------------- Installing component UT_BE_TRUE No errors. -------------------------------------------------------------- Installing component UT_EQUAL No errors. -------------------------------------------------------------- Installing component UT_CONTAIN No errors. -------------------------------------------------------------- Installing component UT_HAVE_COUNT No errors. -------------------------------------------------------------- Installing component UT_BE_BETWEEN No errors. -------------------------------------------------------------- Installing component UT_BE_EMPTY No errors. -------------------------------------------------------------- Installing component UT_MATCH No errors. -------------------------------------------------------------- Installing component UT_EXPECTATION No errors. -------------------------------------------------------------- Installing component UT_JSON_LEAF No errors. -------------------------------------------------------------- Installing component UT_JSON_TREE_DETAILS No errors. -------------------------------------------------------------- Installing component UT_CURSOR_COLUMN No errors. -------------------------------------------------------------- Installing component UT_CURSOR_DETAILS No errors. -------------------------------------------------------------- Installing component UT_EXPECTATION_COMPOUND No errors. -------------------------------------------------------------- Installing component UT_EXPECTATION_JSON No errors. -------------------------------------------------------------- Installing component UT_MATCHER_OPTIONS_ITEMS No errors. -------------------------------------------------------------- Installing component UT_MATCHER_OPTIONS No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE No errors. -------------------------------------------------------------- Installing component UT_COMPOUND_DATA_VALUE No errors. -------------------------------------------------------------- Installing component UT_COMPOUND_DATA_HELPER No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_BLOB No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_BOOLEAN No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_CLOB No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_DATE No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_DSINTERVAL No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_NUMBER No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_REFCURSOR No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_ANYDATA No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_TIMESTAMP No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_TIMESTAMP_TZ No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_TIMESTAMP_LTZ No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_VARCHAR2 No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_YMINTERVAL No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_XMLTYPE No errors. -------------------------------------------------------------- Installing component UT_DATA_VALUE_JSON No errors. -------------------------------------------------------------- Installing component UT_MATCHER No errors. -------------------------------------------------------------- Installing component UT_COMPARISON_MATCHER No errors. -------------------------------------------------------------- Installing component UT_BE_FALSE No errors. -------------------------------------------------------------- Installing component UT_BE_GREATER_OR_EQUAL No errors. -------------------------------------------------------------- Installing component UT_BE_GREATER_THAN No errors. -------------------------------------------------------------- Installing component UT_BE_LESS_OR_EQUAL No errors. -------------------------------------------------------------- Installing component UT_BE_LESS_THAN No errors. -------------------------------------------------------------- Installing component UT_BE_LIKE No errors. -------------------------------------------------------------- Installing component UT_BE_NOT_NULL No errors. -------------------------------------------------------------- Installing component UT_BE_NULL No errors. -------------------------------------------------------------- Installing component UT_BE_TRUE No errors. -------------------------------------------------------------- Installing component UT_EQUAL No errors. -------------------------------------------------------------- Installing component UT_CONTAIN No errors. -------------------------------------------------------------- Installing component UT_HAVE_COUNT No errors. -------------------------------------------------------------- Installing component UT_BE_BETWEEN No errors. -------------------------------------------------------------- Installing component UT_BE_EMPTY No errors. -------------------------------------------------------------- Installing component UT_MATCH No errors. -------------------------------------------------------------- Installing component UT_EXPECTATION No errors. -------------------------------------------------------------- Installing component UT_EXPECTATION_COMPOUND No errors. -------------------------------------------------------------- Installing component UT_EXPECTATION_JSON No errors. -------------------------------------------------------------- Installing component UT_KEY_ANYVALUES No errors. -------------------------------------------------------------- Installing component UT_DOCUMENTATION_REPORTER No errors. -------------------------------------------------------------- Installing component UT_DOCUMENTATION_REPORTER No errors. -------------------------------------------------------------- Installing component UT_RUNNER No errors. -------------------------------------------------------------- Installing component UT_RUNNER No errors. -------------------------------------------------------------- Installing component UT No errors. -------------------------------------------------------------- Installing component UT No errors. -------------------------------------------------------------- Installing component UT_DEBUG_REPORTER No errors. -------------------------------------------------------------- Installing component UT_DEBUG_REPORTER No errors. -------------------------------------------------------------- Installing component UT_TEAMCITY_REPORTER No errors. -------------------------------------------------------------- Installing component UT_TEAMCITY_REPORTER_HELPER No errors. -------------------------------------------------------------- Installing component UT_TEAMCITY_REPORTER_HELPER No errors. -------------------------------------------------------------- Installing component UT_TEAMCITY_REPORTER No errors. -------------------------------------------------------------- Installing component UT_JUNIT_REPORTER No errors. -------------------------------------------------------------- Installing component UT_JUNIT_REPORTER No errors. -------------------------------------------------------------- Installing component UT_TFS_JUNIT_REPORTER No errors. -------------------------------------------------------------- Installing component UT_TFS_JUNIT_REPORTER No errors. -------------------------------------------------------------- Installing component UT_XUNIT_REPORTER No errors. -------------------------------------------------------------- Installing component UT_XUNIT_REPORTER No errors. -------------------------------------------------------------- Installing component UT_SONAR_TEST_REPORTER No errors. -------------------------------------------------------------- Installing component UT_SONAR_TEST_REPORTER No errors. -------------------------------------------------------------- Installing component UT_COVERAGE_HTML_REPORTER No errors. -------------------------------------------------------------- Installing component UT_COVERAGE_REPORT_HTML_HELPER No errors. -------------------------------------------------------------- Installing component UT_COVERAGE_REPORT_HTML_HELPER No errors. -------------------------------------------------------------- Installing component UT_COVERAGE_HTML_REPORTER No errors. -------------------------------------------------------------- Installing component UT_COVERAGE_SONAR_REPORTER No errors. -------------------------------------------------------------- Installing component UT_COVERAGE_SONAR_REPORTER No errors. -------------------------------------------------------------- Installing component UT_COVERALLS_REPORTER No errors. -------------------------------------------------------------- Installing component UT_COVERALLS_REPORTER No errors. -------------------------------------------------------------- Installing component UT_COVERAGE_COBERTURA_REPORTER No errors. -------------------------------------------------------------- Installing component UT_COVERAGE_COBERTURA_REPORTER No errors. -------------------------------------------------------------- Installing component UT_REALTIME_REPORTER No errors. -------------------------------------------------------------- Installing component UT_REALTIME_REPORTER No errors. -------------------------------------------------------------- Installing component BE_BETWEEN No errors. -------------------------------------------------------------- Installing component BE_EMPTY No errors. -------------------------------------------------------------- Installing component BE_FALSE No errors. -------------------------------------------------------------- Installing component BE_GREATER_OR_EQUAL No errors. -------------------------------------------------------------- Installing component BE_GREATER_THAN No errors. -------------------------------------------------------------- Installing component BE_LESS_OR_EQUAL No errors. -------------------------------------------------------------- Installing component BE_LESS_THAN No errors. -------------------------------------------------------------- Installing component BE_LIKE No errors. -------------------------------------------------------------- Installing component BE_NOT_NULL No errors. -------------------------------------------------------------- Installing component BE_NULL No errors. -------------------------------------------------------------- Installing component BE_TRUE No errors. -------------------------------------------------------------- Installing component EQUAL No errors. -------------------------------------------------------------- Installing component HAVE_COUNT No errors. -------------------------------------------------------------- Installing component MATCH No errors. -------------------------------------------------------------- Installing component CONTAIN No errors. -------------------------------------------------------------- Validating installation -------------------------------------------------------------- Installation completed successfully -------------------------------------------------------------- define ut3_user=PUBLIC Granting privileges on UTPLSQL objects in UT3 schema to user PUBLIC Session altered. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. define ut3_user=PUBLIC Session altered. Creating synonyms for UTPLSQL objects in UT3 schema to user PUBLIC Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Synonym created. Installing component UT_TRIGGER_ANNOTATION_PARSING No errors. -------------------------------------------------------------- Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP and Data Mining options oraprod@dpx01db02$