TOracleEvent Stop - Hanging application

[jrb]

Hello
I'm using a TOracleEvent connected to a dbms_alert. This runs fine and I get Timeouts and Alerts popped into my application - BUT - Every time my application attempts to stop the event on shutting down everything hangs Event.Stop is the last call processed. Performance monitor shows no further CPU activity on any of the threads of the application.

The code I'm using the create the event is

FEvent := TOracleEvent.Create(Nil);
FEvent.Timeout := 1;
FEvent.ObjectNames := FTable.Triggers0].Alert;
FEvent.Session := FHandler.Session;
FEvent.ObjectType := otAlert;
FEvent.OnTimeOut := DoOnTimeout;
FEvent.OnEvent := DoOnEvent;
FEvent.Synchronized := True;

and then just

FEvent.Start
and
FEvent.Stop
as needed.

Anyone got any thoughts?

 

[Marco Kalter]

Do you mean that this simple start/stop scenario fails? What is the exact Oracle Server version you are using?

------------------
Marco Kalter
Allround Automations

 

[jrb]

Hi Marco,
Thanks for the reply.
I'm using 8.0.5 - After some searching I found a FAQ which said this version of Oracle had problems with DBMS_Alert so have upgraded now to 8.1.7 and everything seems ok.
BTW - The example I gave used to work fine on the 8.0.5 server provided I had a timeout value set. If I didn't then it would always lock. If I did then I worked ok, Its been like that for months and then suddenly out of the blue decided to throw a wobbler.
Cheers
Richard