bz_xml_cr_q.sql

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

REM script name: bz_xml_cr_q.sql
REM Creates an xml-typed queue bzcardxmlo_qt 
REM
REM version: 9i
REM change:  no connect required
REM

REM =======================================================
REM cleanup section
REM =======================================================
BEGIN
  dbms_aqadm.stop_queue (
        queue_name              => 'bzcardxmlo_q');
END;
/
BEGIN
  dbms_aqadm.drop_queue (
        queue_name              => 'bzcardxmlo_q');
END;
/
BEGIN
  dbms_aqadm.drop_queue_table (
        queue_table => 'bzcardxmlo_qt', force => true);
END;
/

REM =======================================================
REM Create xml-typed queue table, and  queue
REM =======================================================

 execute dbms_aqadm.create_queue_table(		 -
        queue_table => 'bzcardxmlo_qt', -
        comment => 'Order Entry Consumer Orders queue table',	-
        queue_payload_type => 'bzcardxmlo_typ',-
        multiple_consumers => TRUE, -
	primary_instance => 1,-
        secondary_instance => 2);


REM =======================================================
REM Create a queue for New Orders for BZADM
REM =======================================================
BEGIN
dbms_aqadm.create_queue (
        queue_name              => 'bzcardxmlo_q',
        queue_table             => 'bzcardxmlo_qt');
END;
/
REM =======================================================
REM Start queue bzcardxmlo_q
REM =======================================================
BEGIN
  dbms_aqadm.start_queue (
        queue_name              => 'bzcardxmlo_q');
END;
/