Re: Hang in Execute SQL in debug session
CoffeeK1d
03/22/25 06:44 PM
I was also able to reproduce the issue in 15.0.4. I tried 'select user, sysdate from dual;' and 'null', as you suggested. Both resulted in the test window hung, with the status bar indicating "Executing..."
Attached are my two debug logs.
Steps:
1. Open a test window Alt+t or File|Open|New|Test Window
2. Paste the code below into the test script tab:
declare
-- Local variables here
i integer;
l_name VARCHAR(100);
l_date date;
--P_REF_CUR SYS_REFCURSOR;
begin
-- Test statements here
-- OPEN P_REF_CUR FOR
SELECT USER, SYSDATE
into l_name, l_date
FROM DUAL X;
dbms_output.put_line('l_name = ' || l_name || ' and l_date = ' || l_date);
end;
3. Execute it making sure it runs without errors (ctrl+enter)
4. View the DBMS output verifying the results
5. rerun with debugger (F9)
6. The test window hangs with the status bar message of "Executing..."
7. I can continue to use the application like menus and such but not Test Window, which remains at Executing until you kill the application.
