bz_prp_cr_q.sql

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

REM script name: bz_pr_cr_q.sql
REM Creates queues - bzcardorders_prpq
REM Starts the queue
REM
REM version: 9i
REM

REM =======================================================
REM cleanup section
REM =======================================================
BEGIN
  dbms_aqadm.stop_queue(queue_name => 'bzcardorders_prpq');
  dbms_aqadm.drop_queue (
        queue_name              => 'bzcardorders_prpq');
  dbms_aqadm.drop_queue_table (
        queue_table => 'bzcardorders_qt');
END;
/

REM =======================================================
REM Create a queue to show propagation
REM =======================================================
BEGIN
dbms_aqadm.create_queue (
        queue_name              => 'bzcardorders_prpq',
        queue_table             => 'bzcardorders_qt');
END;
/

REM =======================================================
REM start queue
REM =======================================================
BEGIN
  dbms_aqadm.start_queue (
        queue_name              => 'bzcardorders_prpq');
END;
/