Test window hangs on failure

[NWinkler]

1. I've created a test-table and a test-package withe the appended code.
2. Then I build a .tst on TestWrongValue.
3. I step to the UPDATE-statement
4. PL/SQL-Developer hangs.
5. I start a second instance of PL/SQL-Developer
6. I've killed the test-session
(the SQL-Text contains:
begin
sys.dbms_debug.default_timeout := 3600;
sys.dbms_debug.debug_off;
end;
)
7. in the test-instance this error windows appears:
ORA-02290: CHECK-Constraint (XYZ.C_TEST_TABLE_FIELD_A) verletzt
ORA-06512: in "XYZ.ORAP_TEST", Zeile 6
ORA-06512: in Zeile 3
8. Then a cascade of not logged in message and the above follows and I'm using pskill to stop it.

We've read "Re: Test Window Hangs on Break [Re: storms]" #36731 - 2009-12-10 10:02:59 Re: Test Window Hangs on Break [Re: storms] from Marco Kalter
And proofed all suggestions.
In Tools/Preferences/User Interface/Options, DSA Dialogs I've deleted all lines.

Now I'm testing my packages with SQL/Plus and only when they are free of mistakes with PL/SQL-Developer sometimes, that means seldom.

Have you any further suggestions.

Best regards
Norbert
Windows XP
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL-Developer 7.1.5.1398

--_______________________ the TABLE
create table test_table (
field_a varchar2(1)
)
/
alter table test_table
ADD CONSTRAINT C_test_table_field_a CHECK (
field_a = 'A'
)
/
insert into test_table (field_a) values ('A');

commit;
--________________________ the PACKAGE
CREATE OR REPLACE PACKAGE ORAP_Test
as
procedure TestWrongValue;
END ORAP_Test;
/
CREATE OR REPLACE PACKAGE BODY ORAP_Test
as
procedure TestWrongValue
is
begin
update test_table set field_a = 'B';
end;
END ORAP_Test;
/
--_______________________ the .tst

begin
orap_test.testwrongvalue;
end;

 

[Marco Kalter]

Thanks for the detailed problem report and the test case. We'll check it out.