Hang in Execute SQL in debug session
- Thread starter bhargvi
- Start date
Can you try this with the following script?
If this also fails, then to obtain some more diagnostic information, can you modify the PL/SQL Developer shortcut and add the DebugSQL parameter? For example:
"C:\Program Files\PLSQL Developer 16\plsqldev.exe" DebugSQL
Reproduce the problem with the begin/null/end script above and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 16 directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer 16).
Code:
begin
null;
end;If this also fails, then to obtain some more diagnostic information, can you modify the PL/SQL Developer shortcut and add the DebugSQL parameter? For example:
"C:\Program Files\PLSQL Developer 16\plsqldev.exe" DebugSQL
Reproduce the problem with the begin/null/end script above and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 16 directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer 16).
Thanks. Did it hang for the begin/null/end script? If so, what action were you performing before it hanged?
Yes it did.
The following is the steps I performed:
1. Selected the "Start debugger (F9)" button which started the debug session and highlighted the "begin" line.
2. Selected "Execute SQL in debug session" which bought up a dialog box to enter the SQL to run.
3. Entered "SELECT * FROM DUAL" in dialog box and clicked the "OK" button.
4. Hang
Thanks,
bhargvi
The following is the steps I performed:
1. Selected the "Start debugger (F9)" button which started the debug session and highlighted the "begin" line.
2. Selected "Execute SQL in debug session" which bought up a dialog box to enter the SQL to run.
3. Entered "SELECT * FROM DUAL" in dialog box and clicked the "OK" button.
4. Hang
Thanks,
bhargvi
CoffeeK1d
Member²
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.
View attachment Debug(test_sql_using_null).txt
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.
View attachment Debug(test_sql_using_null).txt
