bz_prp_cr_q.sql

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

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');
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;
/

begin
dbms_aqadm.grant_queue_privilege(privilege => 'ALL', 
                                queue_name => 'bzcardorders_prpq', 
                                grantee => 'bz', 
                                grant_option => TRUE);
end;
/

begin
dbms_aqadm.add_subscriber(queue_name => 'bzcardorders_prpq', 
			  subscriber => sys.aq$_agent('sub1', null, null));
end;
/