When I execute a dbms_scheduler.run on demand while in the debugger (Test window), certain jobs will hang. If the job is to call a shell script on Linux DB, I need to know to exceute DBMS_SCHEDULER.RUN_JOB with USe_Current_Session = false. Otherwise, that command just hangs.
When executing this code normally (not in the debugger), use_current_session needs to be true.
Is there a way in PL/SQL to know we are executing in the test_window? I can ass a parameter, but wondering if this can be done via code.