René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Debug utPLSQL test","articleBody":"# Current Behavior\r\n\r\nIn version 1.1.0 you can run utPLSQL tests. But if you want to debug a utPL/SQL test, some manual steps are involved. There are several ways to do that. \r\n\r\nOne way is to run a utPLSQL test in a worksheet change the code to a simple anonymous PL/SQL block (no SQL*Plus statements are allowed) to enable the `Debug...` context menu option and then select this menu option to launch the debugger. \r\n\r\n## Example\r\n\r\n### 1. Launch Debugger\r\n\r\n![utplsql_1_launch_debugger](https://user-images.githubusercontent.com/3883171/63647366-92f63280-c720-11e9-9c70-de81b81e83f4.png)\r\n\r\n### 2. Debugging Session\r\n\r\n![utplsql_2_debugging_session](https://user-images.githubusercontent.com/3883171/63647381-c1740d80-c720-11e9-8064-8ac41ce9dcb9.png)\r\n\r\n# Expected Behavior\r\n\r\n## Launch the Debugger directly\r\n\r\n1. From the context menu of the Database Connections navigator tree, for one or multiple selected nodes for which a \"Run utPLSQL test\" menu item is available in v1.1.0.\r\n\r\n2. From the Worksheet or PL/SQL editor via context menu, when the \"Run utPLSQL test\" menu item is available in v1.1.0.\r\n\r\n3. From the Realtime Reporter via toolbar.\r\n\r\n4. From the Realtime Reporter via context menu on the overview table for the selected test(s).\r\n\r\n## Out of Scope\r\n\r\nThe following is not in scope of the utPLSQL for SQL Developer extension. At least they are not considered part of this issue.\r\n\r\n### Managing Breakpoints\r\n\r\nBreakpoints need to be set in advance or during the debugging session.  \r\n\r\n### Compiling PL/SQL Code for Debug\r\n\r\nThis needs to be done before starting a debug session. Either for chosen components via SQL Developer or via a script recompiling all relevant code for debug.","author":{"url":"https://github.com/PhilippSalvisberg","@type":"Person","name":"PhilippSalvisberg"},"datePublished":"2019-08-25T08:32:02.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/87/utPLSQL-SQLDeveloper/issues/87"}