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>
Date: Wed, 8 Jun 1994 16:58:22 +0000
Message-ID: <771094702snz_at_rtel.demon.co.uk>
Using Database alerts is fairly simple.
- grant execute privs on DBMS_ALERT package to user
- To send and alert dbms_alert.signal('alter_name','optional message');
- 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 LappinReceived on Wed Jun 08 1994 - 18:58:22 CEST