TOracleEvent (Alert) - Hang on exit

[o-sch]

Hello !
I have a problem with the TOracleEvent.
When the internal Session of the TOracleEvent gets disconnected from the server (simulated with a kill Session) the application hangs on exit.(Sometimes there is a AV)

The OnError-Event fires but that doesn't help me. The state seems to be broken.

Enironment:

[...]
OraEvent.KeepConnection := False;
OraEvent.Syncronized := True;
OrsEvent.Session := MainSession;
[...]

MainSession.ThreadSafe := True;

Oracle-Server 11g

Any ideas to fix this behavior ?

 

[Marco Kalter]

Can you use the OracleMonitor to check which activity actually causes the hang-up?

 

[o-sch]

OracleMonitor-Output:

begin
sys.dbms_alert.signal('001BACC30001', Null);
commit;
end;

because of:

if OraEvent.Started then OraEvent.Stop;