queues… only triggers are more confusing… ok thats wrong… because i learned stuff about queue_schedulers… pretty scary… but thats something completely different and i actually hope, i dont have to write about these… but back to queues…
queue handling is in my point of view pretty strate forward… define a queue message, write a queue writer to put messages in the queue, write a reader to retrieve the messages from the queue… simple… but checking, whats acutally going on on the queue is difficult…
we have sys_aq$_jms_text_messages in the queue, which is actually shown on the queue_table when you do a select on it… great… so how can i get its content?
select msgid, enq_time, enq_uid, qt.user_data.TEXT_VC from MY_QUEUE_TABLE qt where q_name = ‘my_queue’
where as the qt needs to be written out…