René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"DDL Trigger not working","articleBody":"**Describe the bug**\r\nutPLSQL 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.\r\n\r\n**Provide version info**\r\nInformation about utPLSQL and Database version, \r\n```sql\r\n11.2.0.4.0\r\n11.2.0\r\n\r\n\r\nPL/SQL procedure successfully completed.\r\n\r\n\r\nUT_VERSION                                                  \r\n------------------------------------------------------------\r\nv3.1.10.3349\r\n\r\n\r\nBANNER                                                                          \r\n--------------------------------------------------------------------------------\r\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nPL/SQL Release 11.2.0.4.0 - Production\r\nCORE\t11.2.0.4.0\tProduction  \r\nTNS for Solaris: Version 11.2.0.4.0 - Production\r\nNLSRTL Version 11.2.0.4.0 - Production\r\n\r\n\r\nPARAMETER                      VALUE                                   \r\n------------------------------ ----------------------------------------\r\nNLS_LANGUAGE                   ENGLISH                                 \r\nNLS_TERRITORY                  GERMANY                                 \r\nNLS_CURRENCY                   €                                       \r\nNLS_ISO_CURRENCY               GERMANY                                 \r\nNLS_NUMERIC_CHARACTERS         ,.                                      \r\nNLS_CALENDAR                   GREGORIAN                               \r\nNLS_DATE_FORMAT                DD.MM.YYYY HH24:MI:SS                   \r\nNLS_DATE_LANGUAGE              ENGLISH                                 \r\nNLS_SORT                       BINARY                                  \r\nNLS_TIME_FORMAT                HH24:MI:SSXFF                           \r\nNLS_TIMESTAMP_FORMAT           DD.MM.YYYY HH24:MI:SSXFF                \r\nNLS_TIME_TZ_FORMAT             HH24:MI:SSXFF TZR                       \r\nNLS_TIMESTAMP_TZ_FORMAT        DD.MM.YYYY HH24:MI:SSXFF TZR            \r\nNLS_DUAL_CURRENCY              €                                       \r\nNLS_COMP                       BINARY                                  \r\nNLS_LENGTH_SEMANTICS           BYTE                                    \r\nNLS_NCHAR_CONV_EXCP            FALSE                                   \r\n\r\n17 rows selected. \r\n\r\n\r\nPORT_STRING                                                 \r\n------------------------------------------------------------\r\nSVR4-be-64bit-8.1.0\r\n```\r\n\r\n**Information about client software**\r\nWhat client was used to run utPLSQL tests? \r\n--\u003e SQLDeveloper\r\n\r\n**To Reproduce**\r\nSteps to reproduce the behavior:\r\n1. install utPLSQL with DDL trigger\r\n2. create or modify a unit test\r\n3. run ut.run()\r\n4. notice that the new/changed tests are not present\r\n5. run ut_runner.rebuild_annotation_cache()\r\n6. run ut.run()\r\n7. notice the tests are correct now\r\n\r\n**Expected behavior**\r\nWhen 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.\r\n\r\n**Example code**\r\n```sql\r\nselect object_owner, max(parse_time)\r\nfrom ut3.ut_annotation_cache_info\r\ngroup by object_owner;\r\n\r\nOBJECT_OWNER                   MAX(PARSE_TIME)              \r\n------------------------------ -----------------------------\r\nAPPS                           03.07.2020 12:33:09,864321000\r\n\r\n\r\nbegin\r\nif ut3.ut_trigger_check.is_alive() then\r\n   dbms_output.put_line('Trigger alive');\r\nelse\r\n   dbms_output.put_line('Trigger NOT alive');\r\nend if;\r\nend;\r\n\r\nTrigger alive\r\n\r\n\r\nPL/SQL procedure successfully completed.\r\n\r\n\r\nselect *\r\nfrom ut3.ut_annotation_cache\r\nwhere annotation_name = 'suite'\r\nand annotation_text = 'xxpk_ut_test';\r\n\r\nno rows selected\r\n\r\n\r\nCREATE OR REPLACE PACKAGE apps.xxpk_ut_test\r\nAUTHID DEFINER\r\nAS\r\n-- %suite(xxpk_ut_test)\r\n\r\n   -- %test(just testing)\r\n   PROCEDURE t_ut_test;\r\n\r\nEND xxpk_ut_test;\r\n\r\nPackage XXPK_UT_TEST compiled\r\n\r\n\r\nCREATE OR REPLACE PACKAGE BODY apps.xxpk_ut_test\r\nAS\r\n\r\n   PROCEDURE t_ut_test\r\n   IS\r\n   BEGIN\r\n      NULL;\r\n   END;\r\n\r\nEND xxpk_ut_test;\r\n\r\nPackage Body XXPK_UT_TEST compiled\r\n\r\n\r\nselect *\r\nfrom ut3.ut_annotation_cache\r\nwhere annotation_name = 'suite'\r\nand annotation_text = 'xxpk_ut_test';\r\n\r\nno rows selected\r\n\r\n\r\nselect object_owner, max(parse_time)\r\nfrom ut3.ut_annotation_cache_info\r\ngroup by object_owner;\r\n\r\nOBJECT_OWNER                   MAX(PARSE_TIME)              \r\n------------------------------ -----------------------------\r\nAPPS                           03.07.2020 12:33:09,864321000\r\n\r\nselect *\r\nfrom ut3.ut_annotation_cache_info\r\nwhere object_owner = 'APPS'\r\nand object_name = 'XXPK_UT_TEST';\r\n\r\nno rows selected\r\n\r\n\r\nexec ut_runner.rebuild_annotation_cache('APPS');\r\n\r\nPL/SQL procedure successfully completed.\r\n\r\n\r\nselect object_owner, max(parse_time)\r\nfrom ut3.ut_annotation_cache_info\r\ngroup by object_owner;\r\n\r\nOBJECT_OWNER                   MAX(PARSE_TIME)              \r\n------------------------------ -----------------------------\r\nAPPS                           04.07.2020 11:16:48,524991000\r\n\r\n\r\nselect *\r\nfrom ut3.ut_annotation_cache_info\r\nwhere object_owner = 'APPS'\r\nand object_name = 'XXPK_UT_TEST';\r\n\r\n  CACHE_ID OBJECT_OWNER                   OBJECT_NAME                    OBJECT_TYPE                    PARSE_TIME                   \r\n---------- ------------------------------ ------------------------------ ------------------------------ -----------------------------\r\n     41207 APPS                           XXPK_UT_TEST                   PACKAGE                        04.07.2020 11:16:48,524991000\r\n\r\n\r\nselect *\r\nfrom ut3.ut_annotation_cache\r\nwhere annotation_name = 'suite'\r\nand annotation_text = 'xxpk_ut_test';\r\n\r\n  CACHE_ID ANNOTATION_POSITION ANNOTATION_NAME                ANNOTATION_TEXT                SUBOBJECT_NAME                \r\n---------- ------------------- ------------------------------ ------------------------------ ------------------------------\r\n     41207                   4 suite                          xxpk_ut_test                                                 \r\n```\r\n\r\n**Additional context**\r\nInstallation:\r\n```sql\r\n# install utPL/SQL\r\nif [ -f /mnt/dbpatches/utPLSQL/source/install_headless_with_trigger.sql ]; then\r\ncd /mnt/dbpatches/utPLSQL/source\r\nsqlplus \"/ as sysdba\" \u003c\u003cEOF \u003e ~/delphix_log/install_utplsql.log\r\n@install_headless_with_trigger.sql\r\nEOF\r\nfi\r\n\r\n---------------------------------------------------------------------------\r\n\r\noraprod@dpx01db02$ cat install_utplsql.log \r\n\r\nSQL*Plus: Release 11.2.0.4.0 Production on Sun Jun 28 15:26:15 2020\r\n\r\nCopyright (c) 1982, 2013, Oracle.  All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nWith the Partitioning, OLAP and Data Mining options\r\n\r\nSQL\u003e \r\nno rows selected\r\n\r\n\r\n\r\n\r\nCreating utPLSQL user UT3\r\n--------------------------------------------------------------\r\nInstalling utPLSQL v3 framework into UT3 schema\r\n--------------------------------------------------------------\r\nSwitching current schema to UT3\r\n--------------------------------------------------------------\r\nInstalling component UT_DBMS_OUTPUT_CACHE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_VARCHAR2_LIST\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_VARCHAR2_ROWS\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_INTEGER_LIST\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_OBJECT_NAME\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_OBJECT_NAME\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_OBJECT_NAMES\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_KEY_VALUE_PAIR\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_KEY_VALUE_PAIRS\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_REPORTER_INFO\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_REPORTERS_INFO\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_UTILS\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_METADATA\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SAVEPOINT_SEQ\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_UTILS\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_METADATA\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_ANSICONSOLE_HELPER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_ANSICONSOLE_HELPER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SUITE_ITEM_INFO\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SUITE_ITEM_INFO\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SUITE_ITEMS_INFO\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_EVENT_ITEM\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_EVENT_LISTENER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_EVENT_MANAGER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_EVENT_MANAGER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_RUN_INFO\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_RUN_INFO\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_EXPECTATION_RESULT\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_EXPECTATION_RESULTS\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_RESULTS_COUNTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SUITE_ITEM\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SUITE_ITEMS\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_EXECUTABLE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_EXECUTABLES\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_EXECUTABLE_TEST\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_TEST\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_LOGICAL_SUITE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SUITE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SUITE_CONTEXT\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_FILE_MAPPING\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_FILE_MAPPINGS\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERAGE_OPTIONS\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_RUN\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_REPORTER_BASE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_REPORTERS\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component JSON_OBJECTS_SPECS\r\nInstalling json structures specs.\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_MATCHER_OPTIONS_ITEMS\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_MATCHER_OPTIONS\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_KEY_ANYVAL_PAIR\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_KEY_ANYVAL_PAIRS\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_KEY_ANYVALUES\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SESSION_CONTEXT\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SESSION_CONTEXT\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SESSION_INFO\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SESSION_INFO\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_OUTPUT_BUFFER_INFO_TMP\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_OUTPUT_BUFFER_TMP\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_OUTPUT_CLOB_BUFFER_TMP\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_OUTPUT_DATA_ROW\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_OUTPUT_DATA_ROWS\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_OUTPUT_BUFFER_BASE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_OUTPUT_BUFFER_BASE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_OUTPUT_TABLE_BUFFER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_OUTPUT_TABLE_BUFFER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_OUTPUT_CLOB_TABLE_BUFFER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_OUTPUT_CLOB_TABLE_BUFFER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_OUTPUT_REPORTER_BASE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_TRIGGER_CHECK\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_TRIGGER_CHECK\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_ANNOTATION\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_ANNOTATIONS\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_ANNOTATED_OBJECT\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_ANNOTATED_OBJECTS\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_ANNOTATION_OBJ_CACHE_INFO\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_ANNOTATION_OBJS_CACHE_INFO\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_ANNOTATION_CACHE_SEQ\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_ANNOTATION_CACHE_SCHEMA\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_ANNOTATION_CACHE_INFO\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_ANNOTATION_CACHE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_ANNOTATION_CACHE_MANAGER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_ANNOTATION_CACHE_MANAGER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_ANNOTATION_PARSER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_ANNOTATION_PARSER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_ANNOTATION_MANAGER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_ANNOTATION_MANAGER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SUITE_CACHE_ROW\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SUITE_CACHE_ROWS\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SUITE_CACHE_SCHEMA\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SUITE_CACHE_PACKAGE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SUITE_CACHE_SEQ\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SUITE_CACHE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SUITE_CACHE_MANAGER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SUITE_CACHE_MANAGER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SUITE_BUILDER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SUITE_BUILDER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SUITE_MANAGER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SUITE_MANAGER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_EXPECTATION_PROCESSOR\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_EXPECTATION_PROCESSOR\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling PLSQL profiler objects into UT3 schema\r\nPLSQL_PROFILER_RUNS table created\r\nPLSQL_PROFILER_UNITS table created\r\nPLSQL_PROFILER_DATA table created\r\nSequence PLSQL_PROFILER_RUNNUMBER created\r\nInstalling PLSQL profiler objects into UT3 schema\r\nInstalling DBMSPLSQL Tables objects into UT3 schema\r\nInstalling component UT_FILE_MAPPER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_FILE_MAPPER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERAGE_SOURCES_TMP\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERAGE_HELPER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERAGE_HELPER_BLOCK\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERAGE_HELPER_PROFILER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERAGE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERAGE_BLOCK\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERAGE_PROFILER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERAGE_REPORTER_BASE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERAGE_HELPER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERAGE_HELPER_BLOCK\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERAGE_HELPER_PROFILER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERAGE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERAGE_BLOCK\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERAGE_PROFILER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERAGE_REPORTER_BASE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_RESULTS_COUNTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SUITE_ITEM\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_TEST\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_LOGICAL_SUITE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SUITE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SUITE_CONTEXT\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_RUN\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_EXPECTATION_RESULT\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_REPORTER_BASE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_OUTPUT_REPORTER_BASE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_FILE_MAPPING\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_EXECUTABLE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_EXECUTABLE_TEST\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_CONSOLE_REPORTER_BASE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_CONSOLE_REPORTER_BASE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COMPOUND_DATA_TMP\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COMPOUND_DATA_DIFF_TMP\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_JSON_DATA_DIFF_TMP\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COMPOUND_DATA_VALUE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_JSON_LEAF\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_JSON_LEAF_TAB\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_JSON_TREE_DETAILS\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_CURSOR_COLUMN\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_CURSOR_COLUMN_TAB\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_CURSOR_DETAILS\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_BLOB\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_BOOLEAN\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_CLOB\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_DATE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_DSINTERVAL\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_NUMBER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_REFCURSOR\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_ANYDATA\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_TIMESTAMP\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_TIMESTAMP_TZ\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_TIMESTAMP_LTZ\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_VARCHAR2\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_YMINTERVAL\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_XMLTYPE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COMPOUND_DATA_HELPER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_JSON\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_MATCHER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COMPARISON_MATCHER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_BE_FALSE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_BE_GREATER_OR_EQUAL\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_BE_GREATER_THAN\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_BE_LESS_OR_EQUAL\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_BE_LESS_THAN\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_BE_LIKE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_BE_NOT_NULL\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_BE_NULL\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_BE_TRUE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_EQUAL\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_CONTAIN\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_HAVE_COUNT\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_BE_BETWEEN\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_BE_EMPTY\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_MATCH\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_EXPECTATION\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_JSON_LEAF\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_JSON_TREE_DETAILS\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_CURSOR_COLUMN\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_CURSOR_DETAILS\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_EXPECTATION_COMPOUND\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_EXPECTATION_JSON\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_MATCHER_OPTIONS_ITEMS\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_MATCHER_OPTIONS\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COMPOUND_DATA_VALUE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COMPOUND_DATA_HELPER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_BLOB\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_BOOLEAN\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_CLOB\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_DATE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_DSINTERVAL\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_NUMBER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_REFCURSOR\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_ANYDATA\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_TIMESTAMP\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_TIMESTAMP_TZ\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_TIMESTAMP_LTZ\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_VARCHAR2\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_YMINTERVAL\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_XMLTYPE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DATA_VALUE_JSON\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_MATCHER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COMPARISON_MATCHER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_BE_FALSE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_BE_GREATER_OR_EQUAL\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_BE_GREATER_THAN\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_BE_LESS_OR_EQUAL\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_BE_LESS_THAN\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_BE_LIKE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_BE_NOT_NULL\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_BE_NULL\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_BE_TRUE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_EQUAL\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_CONTAIN\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_HAVE_COUNT\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_BE_BETWEEN\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_BE_EMPTY\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_MATCH\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_EXPECTATION\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_EXPECTATION_COMPOUND\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_EXPECTATION_JSON\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_KEY_ANYVALUES\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DOCUMENTATION_REPORTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DOCUMENTATION_REPORTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_RUNNER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_RUNNER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DEBUG_REPORTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_DEBUG_REPORTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_TEAMCITY_REPORTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_TEAMCITY_REPORTER_HELPER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_TEAMCITY_REPORTER_HELPER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_TEAMCITY_REPORTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_JUNIT_REPORTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_JUNIT_REPORTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_TFS_JUNIT_REPORTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_TFS_JUNIT_REPORTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_XUNIT_REPORTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_XUNIT_REPORTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SONAR_TEST_REPORTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_SONAR_TEST_REPORTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERAGE_HTML_REPORTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERAGE_REPORT_HTML_HELPER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERAGE_REPORT_HTML_HELPER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERAGE_HTML_REPORTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERAGE_SONAR_REPORTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERAGE_SONAR_REPORTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERALLS_REPORTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERALLS_REPORTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERAGE_COBERTURA_REPORTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_COVERAGE_COBERTURA_REPORTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_REALTIME_REPORTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component UT_REALTIME_REPORTER\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component BE_BETWEEN\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component BE_EMPTY\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component BE_FALSE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component BE_GREATER_OR_EQUAL\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component BE_GREATER_THAN\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component BE_LESS_OR_EQUAL\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component BE_LESS_THAN\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component BE_LIKE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component BE_NOT_NULL\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component BE_NULL\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component BE_TRUE\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component EQUAL\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component HAVE_COUNT\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component MATCH\r\nNo errors.\r\n--------------------------------------------------------------\r\nInstalling component CONTAIN\r\nNo errors.\r\n--------------------------------------------------------------\r\nValidating installation\r\n--------------------------------------------------------------\r\nInstallation completed successfully\r\n--------------------------------------------------------------\r\ndefine ut3_user=PUBLIC\r\nGranting privileges on UTPLSQL objects in UT3 schema to user PUBLIC\r\n\r\nSession altered.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\n\r\nGrant succeeded.\r\n\r\ndefine ut3_user=PUBLIC\r\n\r\nSession altered.\r\n\r\nCreating synonyms for UTPLSQL objects in UT3 schema to user PUBLIC\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\n\r\nSynonym created.\r\n\r\nInstalling component UT_TRIGGER_ANNOTATION_PARSING\r\nNo errors.\r\n--------------------------------------------------------------\r\nDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nWith the Partitioning, OLAP and Data Mining options\r\noraprod@dpx01db02$ \r\n```\r\n","author":{"url":"https://github.com/Sartograph","@type":"Person","name":"Sartograph"},"datePublished":"2020-07-04T10:22:55.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":11},"url":"https://github.com/1088/utPLSQL/issues/1088"}