dbms_aqadm.create_queue_table : dbms_aqadm « System Packages « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Packages
3. dbms_aqadm

SQL>
SQL>
SQL> create or replace type myTable as object (
  2      msg_identifier  VARCHAR2(25),
  3      msg_body        VARCHAR2(100),
  4      msg_date        DATE);
  5  /

Type created.

SQL>
SQL> BEGIN
  2    dbms_aqadm.create_queue_table(
  3      queue_table => 'test_q_table',
  4      queue_payload_type => 'myTable',
  5      comment => 'Test Queue Table') ;
  6    dbms_aqadm.create_queue(
  7      queue_name => 'test_q',
  8      queue_table => 'test_q_table',
  9      comment => 'Test Queue') ;
 10
 11    dbms_aqadm.start_queue('test_q');
 12
 13  END ;
 14  /

PL/SQL procedure successfully completed.

SQL>