Can't stop TOracleEvent

[martinbuhl]

Hi

I have the following problem:

When I call the stop() method on the TOracleEvent component, the program just hangs. The call never returns.

I use Oracle 8.5 and client 9.0.

Hope that somebody can help me.

Martin

 

[Marco Kalter]

Is this Oracle 8.0.5.0.0? In that case you will need to apply the 8.0.5.1.1 patch, which fixes several dbms_alert related issues.

 

[Druching]

Problem is still here. DOA 4.1.2.0, delphi XE, Oracle 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

When i call OracleEvent.Stop programm hangs. Then i see 3 sessions. First - Main App session. And two others Inactive and active. Now app turn back only if i call
sys.DBMS_ALERT.signal ('ALERT_NAME_REGISTRED_IN_CLOSING_EVENT', null);
Same happen when i just close form whith started OracleEvent

 

[vippolito]

I had the same issue. If I remember correctly, I believe if you set the ThreadSafe of the Session to True this will correct the issue. There is an old post in the forum that references this issue.