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

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.

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

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.