bz_prp_add_subscriber.sql

oracle9i+j2ee开发aq oracle9i+j2ee开发aq oracle9i+j2ee开发aq

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', null)-
);

execute dbms_aqadm.remove_subscriber ( -
	  queue_name => 'BZCARDORDERS_Q', -
	  subscriber => sys.aq$_agent('RUSH_ORDER','bzcardorders_prpq',null)-
);
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', null), -
	  rule => 'tab.user_data.ord_typ = ''RUSH''' -
);

quit;
execute dbms_aqadm.add_subscriber ( -
	  queue_name => 'BZCARDORDERS_Q', -
	  subscriber => sys.aq$_agent('RUSH_ORDER','bzcardorders_prpq', null), -
	  rule => 'tab.user_data.ord_typ = ''RUSH''' -
);