bz_add_subscriber.sql

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

REM script name: bz_add_subscriber.sql
REM This script adds a subscriber to bzcardorders_q
REM
REM version: 9i

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

REM =======================================================
REM Add subscriber 'URGENT' to BZCARDORDERS_Q
REM =======================================================
execute dbms_aqadm.add_subscriber ( -
	  queue_name => 'BZCARDORDERS_Q', -
	  subscriber => sys.aq$_agent('URGENT',null,null),-
          rule       => 'tab.user_data.first_name = ''BRAJESH'''-
);