Keywords: Advanced Queue, AQ, AQ Creation, Queue, Queue Creation, How to create a queue, Queue in SOA, SOA, OSB, BPEL
--------------------------------------------------------------------Following are the steps to follow:-
--------------------------------------------------------------------
/* Creating a RAW type queue table and queue: */
BEGIN
DBMS_AQADM.CREATE_QUEUE_TABLE (
queue_table => 'RawMsgs_mahi_qtab',
queue_payload_type => 'RAW');
DBMS_AQADM.CREATE_QUEUE (
queue_name => 'raw_msg_queue_mahi',
queue_table => 'RawMsgs_mahi_qtab');
DBMS_AQADM.START_QUEUE (
queue_name => 'raw_msg_queue_mahi');
END;
--------------------------------------------------------------------
Script to Stop and Drop the Queue:
--------------------------------------------------------------------
EXECUTE dbms_aqadm.stop_queue (queue_name => 'aq_user.msg_queue');
EXECUTE dbms_aqadm.drop_queue (queue_name => 'aq_user.msg_queue');
EXECUTE dbms_aqadm.drop_queue_table (queue_table => 'aq_user.msg_qt');
DROP TYPE aq_user.message_type;