OIC AQ adapter by Niall Commiskey
March 12, 2020 Leave a comment
Queue Setup in Oracle Advanced Queuing
First step was to set up the Q in AQ.
CREATE type Message_typ as object (
subject VARCHAR2(30),
text VARCHAR2(80));
EXECUTE DBMS_AQADM.CREATE_QUEUE_TABLE (queue_table => ‘objmsgs80_qtab’,queue_payload_type => ‘Message_typ’);
EXECUTE DBMS_AQADM.CREATE_QUEUE (queue_name => ‘msg_queue’,queue_table => ‘objmsgs80_qtab’);
EXECUTE DBMS_AQADM.START_QUEUE (queue_name => ‘msg_queue’);
I then created a procedure to create a message –
Read the complete article here.
For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.
Blog 
Twitter 
LinkedIn ![image[7][2][2][2]](https://soacommunity.files.wordpress.com/2013/04/image7222.png?w=20&h=20 "image[7][2][2][2]"){kind=small}
Facebook ![clip_image002[8][4][2][2][2]](https://soacommunity.files.wordpress.com/2013/04/clip_image00284222.jpg?w=26&h=23 "clip_image002[8][4][2][2][2]"){kind=small}
Wiki
Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress
About Jürgen Kress
PaaS Community Blog 