bz_int_add_subscriber.sql

来自「oracle9i+j2ee开发aq oracle9i+j2ee开发aq or」· SQL 代码 · 共 25 行

REM script name: bz_prp_add_subscriber.sql
REM This script adds a subscriber to bzcardorders_q to show
REM propagation
REM version: 9i

REM =======================================================
REM cleanup section
REM =======================================================
execute dbms_aqadm.remove_subscriber ( -
	  queue_name => 'BZCARDORDERS_Q', -
	  subscriber => sys.aq$_agent(null,'bzcardorders_prpq@loopback', null)-
);

execute dbms_aqadm.unschedule_propagation('bzcardorders_q', 'loopback');
REM =======================================================
REM Add remote subscriber to BZCARDORDERS_Q
REM =======================================================

execute dbms_aqadm.add_subscriber ( -
	  queue_name => 'BZCARDORDERS_Q', -
	  subscriber => sys.aq$_agent(null,'bzcardorders_prpq@loopback',null));

execute dbms_aqadm.schedule_propagation('bzcardorders_q', 'loopback');