TOracleEvent doesn't work

[HolgerS]

Hello,

I' trying to use the TOracleEvent Component (Doa4)

OracleEvent.Start sends this SQL :

begin
sys.dbms_alert.register('MyEvent');
sys.dbms_alert.register('000A27E30001');
end;

The first line register my event, what's the matter with the second line created by DOAs?

This call will never return. Is this OK ?

Do I have to write anything else than
begin dbms_alert.signal('MyEvent', 'Test'); end;

in the database side ?

TIA

Holger

 

[Marco Kalter]

The first line register my event, what's the matter with the second line created by DOAs?

The 2nd event is used internally to send a stop signal (TOracleEvent.Stop).

This call will never return. Is this OK ?

No, this is not OK.

Do I have to write anything else than
begin dbms_alert.signal('MyEvent', 'Test'); end;

in the database side ?

Yes, this needs to be committed as well.