René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Cannot navigate to failed test with throws annotation","articleBody":"@tkleiber mentioned this issue at the DOAG conference and sent detailed information via Twitter. I could reproduce it. Here's a simplified version.\r\n\r\n## 1. Create the following package specifications without bodies\r\n\r\n```sql\r\nCREATE OR REPLACE PACKAGE pkg1 IS\r\n   --%suite\r\n   \r\n   --%throws(-20501)\r\n   --%test\r\n   PROCEDURE p;\r\nEND;\r\n/\r\n\r\nCREATE OR REPLACE PACKAGE pkg2 IS\r\n   --%suite\r\n   \r\n   --%test\r\n   PROCEDURE p;\r\nEND;\r\n/\r\n```\r\n\r\n## 2. Run them in a SQL Developer worksheet\r\n\r\n```sql\r\nSET SERVEROUTPUT ON SIZE UNLIMITED\r\nEXECUTE ut.run;\r\n```\r\nand the result looks good:\r\n```\r\npkg1\r\n  p [.11 sec] (FAILED - 1)\r\n \r\npkg2\r\n  p [.094 sec] (FAILED - 2)\r\n \r\nFailures:\r\n \r\n  1) p\r\n      Actual: -4067 was expected to equal: -20501\r\n      ORA-04067: not executed, package body \"SCOTT.PKG1\" does not exist\r\n      ORA-06508: PL/SQL: could not find program unit being called: \"SCOTT.PKG1\"\r\n      ORA-06512: at line 6\r\n       \r\n  2) p\r\n      ORA-04067: not executed, package body \"SCOTT.PKG2\" does not exist\r\n      ORA-06508: PL/SQL: could not find program unit being called: \"SCOTT.PKG2\"\r\n      ORA-06512: at line 6\r\nFinished in .211323 seconds\r\n2 tests, 1 failed, 1 errored, 0 disabled, 0 warning(s)\r\n```\r\n\r\n## 3. Run the same tests with the realtime reporter in SQL Developer\r\n\r\n![image](https://user-images.githubusercontent.com/3883171/70864757-81e26300-1f55-11ea-866b-0fe87bb00446.png)\r\nThis looks good. You can click on the second test and click on every single tab (test, failures, errors, warnings, info). But when you click on the first test the GUI is blocked. You cannot navigate successfully to the first test. The following screenshot shows the inconsistencies.\r\n![image](https://user-images.githubusercontent.com/3883171/70864801-03d28c00-1f56-11ea-978a-e59131808363.png)\r\n\r\n## 4. Workaround (not really)\r\n\r\nCreate a package body for the test with the throws annotation, like this:\r\n\r\n```\r\nCREATE OR REPLACE PACKAGE BODY pkg1 IS\r\n   PROCEDURE p IS\r\n   BEGIN\r\n      raise_application_error(-20501, 'some error');\r\n   END;   \r\nEND;\r\n/\r\n```\r\n\r\nWhen the test succeeds then the GUI behaves as expected. When the test fails, then navigation to the failed test is not possible. \r\n\r\n","author":{"url":"https://github.com/PhilippSalvisberg","@type":"Person","name":"PhilippSalvisberg"},"datePublished":"2019-12-15T15:19:05.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/89/utPLSQL-SQLDeveloper/issues/89"}