Print Thread
TOracleEvent (Alert) - Hang on exit
#47771 08/30/13 07:45 AM
Joined: Aug 2013
Posts: 2
Germany
O
o-sch Offline OP
Member
OP Offline
Member
O
Joined: Aug 2013
Posts: 2
Germany
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 ?

Last edited by o-sch; 08/30/13 07:47 AM.

Using Delphi XE2 / DOA 4.1.3.1
Re: TOracleEvent (Alert) - Hang on exit
o-sch #47772 08/30/13 09:04 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Can you use the OracleMonitor to check which activity actually causes the hang-up?


Marco Kalter
Allround Automations
Re: TOracleEvent (Alert) - Hang on exit
Marco Kalter #47777 08/30/13 01:10 PM
Joined: Aug 2013
Posts: 2
Germany
O
o-sch Offline OP
Member
OP Offline
Member
O
Joined: Aug 2013
Posts: 2
Germany
OracleMonitor-Output:

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


because of:

if OraEvent.Started then OraEvent.Stop;


Using Delphi XE2 / DOA 4.1.3.1

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.070s Queries: 13 (0.014s) Memory: 2.5044 MB (Peak: 3.0418 MB) Data Comp: Off Server Time: 2024-05-18 07:53:45 UTC
Valid HTML 5 and Valid CSS