bz_xml_add_subscriber.sql

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

REM script name: bz_xml_add_subscriber.sql
REM 
REM This script adds an XML subscriber with Transformation
REM
REM version: 9i
REM change:  no connect required 

REM =======================================================
REM cleanup section
REM =======================================================


execute dbms_aqadm.unschedule_propagation(queue_name => 'BZCARDORDERS_Q');

execute dbms_aqadm.remove_subscriber ( -
	  queue_name => 'BZ_ADM.BZCARDORDERS_Q', -
	  subscriber => sys.aq$_agent(null,'BZCARDXMLo_q',null)-
	);

REM =======================================================
REM This is an example of adding an XML transformation
REM =======================================================
execute dbms_aqadm.add_subscriber ( -
	  queue_name => 'BZCARDORDERS_Q', -
	  subscriber => sys.aq$_agent(null,'BZCARDXMLo_q',null),-
	  transformation => 'BZCARDOBJ2XML');

execute dbms_aqadm.schedule_propagation(queue_name => 'BZCARDORDERS_Q');