Problem with TOracleEvent

[jschmied]

I get a ORA-03113 when do:

WFlowEvent := TOracleEvent.Create(nil);
WFlowEvent.Session := OracleSession1;
WFlowEvent.ObjectNames := 'wflow_alert';
WFlowEvent.ObjectType := otAlert;
WFlowEvent.Synchronized := FALSE;
WFlowEvent.OnEvent := WFlowEventEvent;
WFlowEvent.OnStart := WFlowEventStart;
WFlowEvent.OnStop := WFlowEventStop;
...
WFlowEvent.Start();
....
WFlowEvent.Stop();

 

[Marco Kalter]

Both Oracle8 8.0.4 and 8.0.5 have had problems with the dbms_alert package. There was a timing bug that could cause these kinds of problems. For 8.0.4 you need to upgrade to at least 8.0.4.3.2, and for 8.0.5 you need to upgrade to 8.0.5.1.1.

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