Debugger hang on Break

[Shaper]

It easy to reproduce this problem on Oracle 10g(10.2.0.2 on RAC), here are steps:

CREATE OR REPLACE TRIGGER AUDIT_DATABASE_ASE
AFTER SERVERERROR ON DATABASE
BEGIN
END;
END;

Next start debugging any code and finnally call break at any code line - debugger will hang.

Disabling the trigger resolve this problem.

Could you fix the developer to have the ability to use this kind of trigger in the database?

 

[Shaper]

A small misprint:

CREATE OR REPLACE TRIGGER AUDIT_DATABASE_ASE
AFTER SERVERERROR ON DATABASE
BEGIN
RETURN;
END;

 

[Marco Kalter]

Did you add debug information to this trigger?

 

[Shaper]

Yes, because "Add debug information when compiling" option is turned on.

 

[Shaper]

We compiled this trigger with and without debug information and tried to debug in both cases but the problem still occured. Having this trigger with just one code line "return" in the database cause the problem.

Disabling the trigger resolve this problem.

Have you reproduced the problem?

 

[Shaper]

Marco, have you reproduced the problem?

 

[Marco Kalter]

We'll look into this.