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>