executing dbms_alert package
EZGmsAug 4 2011 — edited Aug 4 2011Hi,
I need to have news when a new record is inserted in a table,
and I think the best way is :
1º create an AFTER INSERT OR UPDATE trigger with dbms_alert.signal('emptab_alert', msg);
2º create a procedure with:
a) dbms_alert.register('emptab_alert');
b) dbms_alert.waitone('emptab_alert', msg, stat);
c) dbms_output.put_line('Msg: ' || msg || ' Stat: ' || TO_CHAR(stat));
finally when I execute the procedure, this don't stop
what could I do to resolve the issue?
many Thanks...