RIB - To Move message from ERROR queue to Normal Queue
PT : RIB - Mover mensagem da ERROR queue para Normal Queue EN : RIB - To Move message from ERROR queue to Normal Queue
Posts
Showing posts with the label Oracle AQ
RIB - Extract a payload from a Oracle Queue
- Get link
- X
- Other Apps
English Version Neste post partilho uma a query usada para extratir o mensagens de systemas Oracle AQ queues/topicos. set lines 300 col enq_time form a30 col deq_time form a10 col msg form a100 set longchunksize 30000 set long 30000 select msgid,enq_time, deq_time, r.user_data.text_lob msg from ribaq.etitemsfromrmstable r where enq_time > sysdate - 1 and r.user_data.text_lob like '%101715654%' order by enq_time; Obrigado pela leitura, espero que este post o tenha ajudado. Versao Portuguesa In post I'm shared a query I used to run to see payload messages in Oracle AQ queues / topics . set lines 300 col enq_time form a30 col deq_time form a10 col msg form a100 set longchunksize 30000 set long 30000 select msgid,enq_time, deq_time, r.user_data.text_lob msg from ribaq.etitemsfromrmstable r where enq_time > sysdate - 1 and r.u...