René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"ORA-08402: error executing PL/SQL code coverage","articleBody":"**Describe the bug**\r\nRunning with UT_COVERAGE_HTML_REPORTER reporter from utplsql-cli throws oracle error.\r\nThe normal UT_DOCUMENTATION_REPORTER runs all testcases successfully.\r\n\r\n**Provide version info**\r\n12.2.0.1.0\r\n12.2.0\r\n\r\n\r\nPL/SQL procedure successfully completed.\r\n\r\n\r\nUT_VERSION                                                  \r\nv3.1.10.3349\r\n\r\n\r\nBANNER                                                                               CON_ID\r\n-------------------------------------------------------------------------------- ----------\r\nOracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production              0\r\nPL/SQL Release 12.2.0.1.0 - Production                                                    0\r\nCORE\t12.2.0.1.0\tProduction                                                                  0\r\nTNS for Linux: Version 12.2.0.1.0 - Production                                            0\r\nNLSRTL Version 12.2.0.1.0 - Production                                                    0\r\n\r\n\r\nPARAMETER                      VALUE                                                           \r\n------------------------------ ----------------------------------------------------------------\r\nNLS_LANGUAGE                   ENGLISH                                                         \r\nNLS_TERRITORY                  AUSTRIA                                                         \r\nNLS_CURRENCY                   ¿                                                               \r\nNLS_ISO_CURRENCY               AUSTRIA                                                         \r\nNLS_NUMERIC_CHARACTERS         ,.                                                              \r\nNLS_CALENDAR                   GREGORIAN                                                       \r\nNLS_DATE_FORMAT                DD.MM.RR 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.RR HH24:MI:SSXFF                                          \r\n\r\nPARAMETER                      VALUE                                                           \r\n------------------------------ ----------------------------------------------------------------\r\nNLS_TIME_TZ_FORMAT             HH24:MI:SSXFF TZR                                               \r\nNLS_TIMESTAMP_TZ_FORMAT        DD.MM.RR 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\nx86_64/Linux 2.4.xx\r\n\r\n\r\n\r\n**Information about client software**\r\nutplsql-cli\r\n\r\n$ ./utplsql info                                                                                                                                                                                                                         utPLSQL-cli 3.1.8-SNAPSHOT.local                                                                                                                                                                                                         utPLSQL-java-api 3.1.8.546\r\n\r\n\r\n\r\n**Additional context**\r\n2020-09-04 11:57:08 [main] INFO  org.utplsql.cli.RunAction - \r\n############################ utPLSQL cli #############################\r\n   utPLSQL-cli 3.1.8-SNAPSHOT.local                                 #\r\n   utPLSQL-java-api 3.1.8.546                                       #\r\n   Java-Version: 1.8.0_201                                          #\r\n   ORACLE_HOME: ##############################                      #\r\n   NLS_LANG: AMERICAN_AMERICA.UTF8                                  #\r\n                                                                    #\r\n   Thanks for testing!                                              #\r\n                                                                    #\r\n######################################################################\r\n2020-09-04 11:57:08 [main] INFO  org.utplsql.cli.RunAction -\r\n2020-09-04 11:57:09 [main] DEBUG o.u.c.d.TestedDataSourceProvider - NLS settings: BEGIN\r\nEXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_LANGUAGE='AMERICAN']';\r\nEXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_TERRITORY='AMERICA']';\r\nEND;\r\n2020-09-04 11:57:09 [main] INFO  o.u.c.d.TestedDataSourceProvider - Use connection string jdbc:oracle:thin:****/****@***\r\n2020-09-04 11:57:10 [main] INFO  org.utplsql.cli.RunAction - Successfully connected to database. UtPLSQL core: v3.1.10.3349\r\n2020-09-04 11:57:10 [main] INFO  org.utplsql.cli.RunAction - Oracle-Version: 12.2.0.1.0\r\n2020-09-04 11:57:10 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_COVERAGE_HTML_REPORTER, ID: AE7AE470E70F3B7AE0530101007FF44E\r\n2020-09-04 11:57:10 [pool-1-thread-1] INFO  org.utplsql.cli.RunTestRunnerTask - Running tests now.\r\n2020-09-04 11:57:10 [pool-1-thread-1] INFO  org.utplsql.cli.RunTestRunnerTask - --------------------------------------\r\n2020-09-04 11:57:10 [pool-1-thread-1] INFO  org.utplsql.api.TestRunner - TestRunner initialized\r\n2020-09-04 11:57:10 [pool-1-thread-1] INFO  org.utplsql.api.TestRunner - Running on utPLSQL v3.1.10.3349\r\n2020-09-04 11:57:10 [pool-1-thread-1] INFO  org.utplsql.api.TestRunner - Initializing reporters\r\n2020-09-04 11:57:10 [pool-1-thread-1] INFO  org.utplsql.api.TestRunner - Running tests\r\nORA-08402: error executing PL/SQL code coverage\r\nORA-06512: at \"UT3.UT_RUNNER\", line 180\r\nORA-06512: at \"SYS.DBMS_PLSQL_CODE_COVERAGE\", line 148\r\nORA-06512: at \"UT3.UT_COVERAGE_HELPER_BLOCK\", line 45\r\nORA-06512: at \"UT3.UT_COVERAGE\", line 221\r\nORA-06512: at \"UT3.UT_COVERAGE_HTML_REPORTER\", line 34\r\nORA-06512: at \"UT3.UT_REPORTER_BASE\", line 193\r\nORA-06512: at \"UT3.UT_EVENT_MANAGER\", line 70\r\nORA-06512: at \"UT3.UT_EVENT_MANAGER\", line 80\r\nORA-06512: at \"UT3.UT_RUN\", line 74\r\nORA-06512: at \"UT3.UT_SUITE_ITEM\", line 49\r\nORA-06512: at \"UT3.UT_RUNNER\", line 172\r\nORA-06512: at line 1\r\n\r\njava.sql.SQLException: ORA-08402: error executing PL/SQL code coverage\r\nORA-06512: at \"UT3.UT_RUNNER\", line 180\r\nORA-06512: at \"SYS.DBMS_PLSQL_CODE_COVERAGE\", line 148\r\nORA-06512: at \"UT3.UT_COVERAGE_HELPER_BLOCK\", line 45\r\nORA-06512: at \"UT3.UT_COVERAGE\", line 221\r\nORA-06512: at \"UT3.UT_COVERAGE_HTML_REPORTER\", line 34\r\nORA-06512: at \"UT3.UT_REPORTER_BASE\", line 193\r\nORA-06512: at \"UT3.UT_EVENT_MANAGER\", line 70\r\nORA-06512: at \"UT3.UT_EVENT_MANAGER\", line 80\r\nORA-06512: at \"UT3.UT_RUN\", line 74\r\nORA-06512: at \"UT3.UT_SUITE_ITEM\", line 49\r\nORA-06512: at \"UT3.UT_RUNNER\", line 172\r\nORA-06512: at line 1\r\n\r\n        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)\r\n        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)\r\n        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)\r\n        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)\r\n        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)\r\n        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)\r\n        at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:265)\r\n        at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:86)\r\n        at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:965)\r\n        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205)\r\n        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)\r\n        at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1358)\r\n        at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3778)\r\n        at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4251)\r\n        at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1081)\r\n        at org.utplsql.api.testRunner.DynamicTestRunnerStatement.execute(DynamicTestRunnerStatement.java:84)\r\n        at org.utplsql.api.TestRunner.run(TestRunner.java:213)\r\n        at org.utplsql.cli.RunTestRunnerTask.call(RunTestRunnerTask.java:45)\r\n        at org.utplsql.cli.RunTestRunnerTask.call(RunTestRunnerTask.java:24)\r\n        at java.util.concurrent.FutureTask.run(FutureTask.java:266)\r\n        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\r\n        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\r\n        at java.lang.Thread.run(Thread.java:748)\r\nCaused by: Error : 8402, Position : 0, Sql = BEGIN ut_runner.run(a_paths =\u003e :1 , a_reporters =\u003e :2 , a_color_console =\u003e (case :3  when 1 then true else false end), a_fail_on_errors =\u003e (case :4  when 1 then true else false end), a_client_character_set =\u003e :5 , a_random_test_order =\u003e (case :6  when 1 then true else false end));END;, OriginalSql = BEGIN ut_runner.run(a_paths =\u003e ?, a_reporters =\u003e ?, a_color_console =\u003e (case ? when 1 then true else false end), a_fail_on_errors =\u003e (case ? when 1 then true else false end), a_client_character_set =\u003e ?, a_random_test_order =\u003e (case ? when 1 then true else false end));END;, Error Msg = ORA-08402: error executing PL/SQL code coverage\r\nORA-06512: at \"UT3.UT_RUNNER\", line 180\r\nORA-06512: at \"SYS.DBMS_PLSQL_CODE_COVERAGE\", line 148\r\nORA-06512: at \"UT3.UT_COVERAGE_HELPER_BLOCK\", line 45\r\nORA-06512: at \"UT3.UT_COVERAGE\", line 221\r\nORA-06512: at \"UT3.UT_COVERAGE_HTML_REPORTER\", line 34\r\nORA-06512: at \"UT3.UT_REPORTER_BASE\", line 193\r\nORA-06512: at \"UT3.UT_EVENT_MANAGER\", line 70\r\nORA-06512: at \"UT3.UT_EVENT_MANAGER\", line 80\r\nORA-06512: at \"UT3.UT_RUN\", line 74\r\nORA-06512: at \"UT3.UT_SUITE_ITEM\", line 49\r\nORA-06512: at \"UT3.UT_RUNNER\", line 172\r\nORA-06512: at line 1\r\n\r\n        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)\r\n        ... 22 more\r\n\r\n","author":{"url":"https://github.com/geriweg","@type":"Person","name":"geriweg"},"datePublished":"2020-09-04T10:02:43.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":11},"url":"https://github.com/1097/utPLSQL/issues/1097"}