RE: HELP DB_ALERT

From: Stephen Lappin <SL_at_rtel.demon.co.uk>
Date: Wed, 8 Jun 1994 16:58:22 +0000
Message-ID: <771094702snz_at_rtel.demon.co.uk>


Using Database alerts is fairly simple.

  1. grant execute privs on DBMS_ALERT package to user
  2. To send and alert dbms_alert.signal('alter_name','optional message');
  3. To look out for alerts, first register your interest this dbms_alert.register('alert_name'); Then wait for it.. dbms_alert.waitone('alert_name','message',status,timeout); You will get the optional message returned and status=0 when the alert is sent.
-- 
Stephen Lappin
Received on Wed Jun 08 1994 - 18:58:22 CEST

Original text of this message