TOracleEvent is missing events

[Nastya]

Hi!
Does anybody knows what to do with Oracle alerts sent one after one ? PL SQL code looks like this :
begin
dbms_alert.signal(alerttype.name , 'some string 1');
dbms_alert.signal(alerttype.name , 'some string 1');
end;

TOracleEvent used in my program can easily get only the LAST event. (When send in some period there's no problem, but the sequence of several dbms_alert.signal calls causes the information lost). What should I do ?

 

[Marco Kalter]

You can indeed miss dbms_alerts if they are fired quickly after another. If you want to be sure that you do not miss any event, you could consider using dbms_pipe messages instead (which uses a queue mechanism).

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