René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Coverage not being reported when DBMS_SCHEDULER.RUN_JOB is in tests","articleBody":"**Describe the bug**\r\nWhen running code coverage, I get 0% code coverage is `DBMS_SCHEDULER.RUN_JOB` is called in the tests\r\n\r\nbelow is my test:\r\n```\r\nbegin\r\n    dbms_scheduler.run_job(\r\n        job_name            =\u003e  c_full_job_name,\r\n        use_current_session =\u003e  true\r\n    );\r\n\r\n    select status\r\n    into l_actual\r\n    from all_scheduler_job_run_details\r\n    where owner = c_owner\r\n        and job_name = c_job_name\r\n    order by log_date desc\r\n    fetch first 1 rows only;\r\n\r\n    ut.expect(l_actual).to_equal(c_succeeded);\r\nend check_purge_job_runs;\r\n```\r\n\r\ncommenting out the `DBMS_SCHEDULER.RUN_JOB` call returns all the code coverages to expected values.\r\n\r\n**Provide version info**\r\nInformation about utPLSQL and Database version, \r\n```sql\r\nSQL\u003e set serveroutput on\r\nSQL\u003e declare\r\n  2    l_version varchar2(255);\r\n  3    l_compatibility varchar2(255);\r\n  4  begin\r\n  5    dbms_utility.db_version( l_version, l_compatibility );\r\n  6    dbms_output.put_line( l_version );\r\n  7    dbms_output.put_line( l_compatibility );\r\n  8  end;\r\n  9* /\r\n19.0.0.0.0\r\n19.0.0\r\n\r\n\r\nPL/SQL procedure successfully completed.\r\n\r\nSQL\u003e select substr(ut.version(),1,60) as ut_version from dual;\r\n\r\nUT_VERSION\r\n_______________\r\nv3.1.12.3589\r\n\r\nSQL\u003e select * from v$version;\r\n\r\nBANNER                                                                    BANNER_FULL                                                                                   BANNER_LEGACY                                                                CON_ID\r\n_________________________________________________________________________ _____________________________________________________________________________________________ _________________________________________________________________________ _________\r\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production    Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\r\nVersion 19.21.0.1.0    Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production            0\r\n\r\nSQL\u003e select * from nls_session_parameters;\r\n\r\nPARAMETER                  VALUE\r\n__________________________ _______________________________\r\nNLS_LANGUAGE               AMERICAN\r\nNLS_TERRITORY              AMERICA\r\nNLS_CURRENCY               $\r\nNLS_ISO_CURRENCY           AMERICA\r\nNLS_NUMERIC_CHARACTERS     .,\r\nNLS_CALENDAR               GREGORIAN\r\nNLS_DATE_FORMAT            DD-MON-RR\r\nNLS_DATE_LANGUAGE          AMERICAN\r\nNLS_SORT                   BINARY\r\nNLS_TIME_FORMAT            HH.MI.SSXFF AM\r\nNLS_TIMESTAMP_FORMAT       DD-MON-RR HH.MI.SSXFF AM\r\nNLS_TIME_TZ_FORMAT         HH.MI.SSXFF AM TZR\r\nNLS_TIMESTAMP_TZ_FORMAT    DD-MON-RR HH.MI.SSXFF AM 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\nSQL\u003e select substr(dbms_utility.port_string,1,60) as port_string from dual;\r\n\r\nPORT_STRING\r\n______________________\r\nx86_64/Linux 2.4.xx\r\n```\r\n\r\n**Information about client software**\r\nThis was run in SQLDeveloper and SQLcl (latest versions)\r\n\r\n**To Reproduce**\r\nCreate a test that runs any job with `DBMS_SCHEDULER.RUN_JOB`\r\n\r\n**Expected behavior**\r\nCode coverage to be reported correctly","author":{"url":"https://github.com/jasonlyle88","@type":"Person","name":"jasonlyle88"},"datePublished":"2023-09-28T20:52:51.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":13},"url":"https://github.com/1271/utPLSQL/issues/1271"}