Print Thread
Execute SQL in debug window can easily fail and ends in a state where session can not be terminated
#63161 02/08/22 09:48 AM
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Member
OP Offline
Member
Joined: Dec 2005
Posts: 2,004
Roima Denmark
When executing SQL in debug window, you can easily end in a state, where the SQL can not be executed and the session can not be terminated.

Steps to reproduce:

I have a test window containing the code:
Code
begin
  null;
end;

I press F9 to debug and Ctrl-O to enter the code block.

I press the button 'Execute SQL in debug session...'

I enter the query:
SQL Query
SELECT * FROM v$session

and get the error:
Quote
ORA-06558: buffer in dbms_pipe package is full. No more items allowed
ORA-06512: at "SYS.PBREAK", line 1513
<...>

This, I believe, is by "design" and is a known limitation in the database.

I open the debug session SQL window again and rewrite my SQL into:
SQL Query
SELECT v$session.sid FROM v$session

and get the error:
Quote
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "SYS.PBREAK", line 1363

I try again and get the error:
Quote
ORA-00900: invalid SQL statement

Sometimes I also get the error:
Quote
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.PBRPH", line 905
ORA-06512: at "SYS.DBMS_DEBUG", line 801

Sometimes is has helped to put a semicolon (;) at the end of the select to terminate the statement, but that does not help either.

This all ends in a loop that can not be terminated.

I can not break the debugger and eventually you will have to terminate PL/SQL developer via task manager to e.g. be able to compile program window.

Re: Execute SQL in debug window can easily fail and ends in a state where session can not be terminated
Claus Pedersen #63166 02/08/22 10:04 AM
Joined: Aug 1999
Posts: 22,200
Member
Offline
Member
Joined: Aug 1999
Posts: 22,200
We'll investigate.


Marco Kalter
Allround Automations
Re: Execute SQL in debug window can easily fail and ends in a state where session can not be terminated
Claus Pedersen #63415 02/21/22 10:00 PM
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Member
OP Offline
Member
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Any progress on this?

Re: Execute SQL in debug window can easily fail and ends in a state where session can not be terminated
Claus Pedersen #63427 02/22/22 10:21 AM
Joined: Aug 1999
Posts: 22,200
Member
Offline
Member
Joined: Aug 1999
Posts: 22,200
We have not yet investigated this. It's still on the list.


Marco Kalter
Allround Automations
Re: Execute SQL in debug window can easily fail and ends in a state where session can not be terminated
Claus Pedersen #63452 02/24/22 09:23 AM
Joined: Mar 2007
Posts: 110
Hazerswoude-Dorp, NL
Member
Offline
Member
Joined: Mar 2007
Posts: 110
Hazerswoude-Dorp, NL
Don't know if this is related, but after (successfully) running a debug session a query I execute in another window doesn't return with results and I can only stop this by closing the window, terminate session. After that I receive a ntdll error when I reopen the file and try to execute the query again.
I have also reported this weird query execute state earlier. Working with the beta version is kind of hard because of this bug as I'm trying to debug right now. I now have to close PLSQL Developer after every debug run.


Certainty of death, small chance of succes,
What are we waiting for... (Gimly)
Re: Execute SQL in debug window can easily fail and ends in a state where session can not be terminated
Claus Pedersen #63454 02/24/22 09:43 AM
Joined: Mar 2007
Posts: 110
Hazerswoude-Dorp, NL
Member
Offline
Member
Joined: Mar 2007
Posts: 110
Hazerswoude-Dorp, NL
After debug run I now just tried to open a clob in de query result of a query executed before the debug-run and now receive the following error:
Access violation at address 00007FFA08CD5CAF in module 'OraClient12.Dll'. Read of address 00000000149B4DD4


Certainty of death, small chance of succes,
What are we waiting for... (Gimly)
Re: Execute SQL in debug window can easily fail and ends in a state where session can not be terminated
Claus Pedersen #63456 02/24/22 10:36 AM
Joined: Mar 2007
Posts: 110
Hazerswoude-Dorp, NL
Member
Offline
Member
Joined: Mar 2007
Posts: 110
Hazerswoude-Dorp, NL
ntdll.dll error mentioned above is the following:
Access violation at address 00007FFA33D9D589 in module 'ntdll.dll'. Write of address 000000001720F7A0


Certainty of death, small chance of succes,
What are we waiting for... (Gimly)
Re: Execute SQL in debug window can easily fail and ends in a state where session can not be terminated
Claus Pedersen #63686 03/25/22 08:38 AM
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Member
OP Offline
Member
Joined: Dec 2005
Posts: 2,004
Roima Denmark
@Marco, please address this issue before the final version 15 release


Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.032s Queries: 15 (0.007s) Memory: 2.5330 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-04-20 11:02:42 UTC
Valid HTML 5 and Valid CSS