First step was to set up the Q in AQ.
CREATE type Message_typ as object (
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 –
For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.