PLSQL Debugger Hangs on PLSQL Errors

[Mshea]

When an Error occurs in the Debug Window, PLSQL developer hangs.

Try the following and see for yourself (establish the variables first):

lvdEffDate := TO_DATE( in_EffDate );

Obviously, its a syntax error (missing date format) but creates the hanging scenario every time. What can be done to prevent PLSQL from hanging on errors like this?

The error message will eventually come up when the session is killed, through Tools/Session only.

 

[ScottMattes]

It works just fine for me in both the beta 4 and 5.1.5.744 versions

 

[Marco Kalter]

Can you let me know your PL/SQL Developer version (Help > About screen)?

 

[Mshea]

PL/SQL Developer
Version 5.1.0.654 (MBCS)
01.13839 - 50 user license
Windows NT version 4.0 (build 1381) Service Pack 5

Oracle 9i

 

[Mshea]

The Complete Test Script is below.
It hangs on the TO_DATE() line.

-- Created on 7/23/2004 by MSHEA
declare
-- Local variables here
lvdEffDate Date;
in_EffDate Varchar2(10);
begin
-- Test statements here
in_EffDate := '2004-01-02';
lvdEffDate := TO_DATE( in_EffDate );
dbms_output.put_line('Date ' || in_EffDate);

end;

 

[Marco Kalter]

Can you apply the 5.1.6 patch and try again? Let me know how this turns out.

 

[Mshea]

I've upgraded to 5.1.6 and it no longer hangs.
Thanks!

 

[Mshea]

Spoke too soon. Still hanging.
It caught a syntax error rather quickly but hung again on this same line.