qs_ia_cr_q.sql.old

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

REM script name: qs_cre.sql
REM Create queue tables, queues for Queued Shipping
REM
REM version: 9i
REM change:  no connect required
REM

REM =======================================================
REM cleanup section
REM =======================================================
BEGIN
  dbms_aqadm.drop_queue (
        queue_name              => 'QS_neworders_que');
  dbms_aqadm.drop_queue_table (
        queue_table => 'QS_orders_sqtab');
END;
/

REM =======================================================
REM Create queue tables, queues for QSADM
REM =======================================================

 execute dbms_aqadm.create_queue_table(					-
        queue_table => 'QS_orders_sqtab',				-
        comment => 'Order Entry Single Consumer Orders queue table',	-
        queue_payload_type => 'QS_ADM.order_typ',			-
        compatible => '8.1.0',						-
        primary_instance => 1,						-
        secondary_instance => 2);


REM =======================================================
REM Create a queue for New Orders for QSADM
REM =======================================================
BEGIN
dbms_aqadm.create_queue (
        queue_name              => 'QS_neworders_que',
        queue_table             => 'QS_orders_sqtab');
END;
/