René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Under Oracle EE 18.5.0.0.0 tests with %beforeeach or %aftereach fails with ORA-20204.","articleBody":"**Describe the bug**\r\nUnder Oracle EE 18.5.0.0.0 tests with %beforeeach or %aftereach fails with ORA-20204.\r\nORA-20204: Suite test \u003cbefore/after each procedure\u003e does not exist\r\nBut both exist!\r\n\r\n**Provide version info**\r\nInformation about utPLSQL and Database version, \r\n```sql\r\nset serveroutput on\r\ndeclare\r\n  l_version varchar2(255);\r\n  l_compatibility varchar2(255);\r\nbegin\r\n  dbms_utility.db_version( l_version, l_compatibility );\r\n  dbms_output.put_line( l_version );\r\n  dbms_output.put_line( l_compatibility );\r\nend;\r\n/\r\n\r\n==\u003e\r\nPL/SQL block executed\r\n18.0.0.0.0\r\n18.0.0\r\n\r\n-\u003e this query is wrong for 18c upwards, the sqlplus header shows us:\r\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\r\nVersion 18.5.0.0.0\r\n\r\nselect substr(ut.version(),1,60) as ut_version from dual;\r\nv3.1.6.2735\r\n\r\nselect * from v$version;\r\n\r\n==\u003e\r\nBANNER                                                                                 BANNER_FULL                                                                                          BANNER_LEGACY                                                                          CON_ID                                       \r\n-------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------- -------------------------------------------- \r\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production                 Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\r\nVersion 18.5.0.0.0            Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production                                                            0 \r\n\r\nselect * from nls_session_parameters;\r\n\r\n==\u003e\r\nPARAMETER                                                                                            VALUE                                                                                                \r\n---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- \r\nNLS_LANGUAGE                                                                                         GERMAN                                                                                               \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.RRRR                                                                                           \r\nNLS_DATE_LANGUAGE                                                                                    GERMAN                                                                                               \r\nNLS_SORT                                                                                             GERMAN                                                                                               \r\nNLS_TIME_FORMAT                                                                                      HH24:MI:SSXFF                                                                                        \r\nNLS_TIMESTAMP_FORMAT                                                                                 DD.MM.RR HH24:MI:SSXFF                                                                               \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                                                                                 CHAR                                                                                                 \r\nNLS_NCHAR_CONV_EXCP                                                                                  FALSE                                                                                                \r\n\r\nselect substr(dbms_utility.port_string,1,60) as port_string from dual;\r\n\r\n==\u003e\r\nPORT_STRING                                                        \r\n------------------------------------------------------------------ \r\nx86_64/Linux 2.4.xx                                                \r\n\r\n```\r\n\r\n**Information about client software**\r\nWhat client was used to run utPLSQL tests? Was it from TOAD, SQLDeveloper, SQLPlus, PLSQL Developer etc...\r\n\r\n**To Reproduce**\r\nSteps to reproduce the behavior:\r\n1. In SQL Developer with utPLSQL extension create the provided test package in Oracle EE 18.5.0.0.0 and open the package\r\n2. Right Click open the context menu in editor and click \"Run utPLSQL Test\"\r\n3. See error in te script output:\r\nORA-06512: at \"UT3.UT_SUITE_MANAGER\", line 680\r\nORA-06512: at \"UT3.UT_RUNNER\", line 150\r\n\r\nORA-20204: Suite test s205031.test_betwnstr.setup does not exist\r\nORA-06512: at \"UT3.UT_SUITE_MANAGER\", line 680\r\n\r\n\r\n\r\nError starting at line : 2 in command -\r\nBEGIN ut.run('S205031.test_betwnstr.setup'); END;\r\nError report -\r\nORA-20204: Suite test s205031.test_betwnstr.setup does not exist\r\nORA-06512: at \"UT3.UT_RUNNER\", line 163\r\nORA-06512: at \"UT3.UT_SUITE_MANAGER\", line 680\r\nORA-06512: at \"UT3.UT_RUNNER\", line 150\r\nORA-06512: at \"UT3.UT\", line 126\r\nORA-06512: at \"UT3.UT\", line 427\r\nORA-06512: at \"UT3.UT\", line 538\r\nORA-06512: at line 1\r\n\r\n**Expected behavior**\r\nThe test should find and run the beforeEach and aftereach procedures. It is possible, that other annotations run into this error, so you should check all.\r\n\r\n**Example code**\r\nWill attach a modified test_betwnstr package to reproduce this issue.\r\n\r\n**Additional context**\r\nAdd any other context about the problem here.\r\n","author":{"url":"https://github.com/tkleiber","@type":"Person","name":"tkleiber"},"datePublished":"2019-03-29T07:05:06.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":9},"url":"https://github.com/884/utPLSQL/issues/884"}