Home » Server Options » Streams & AQ » Dequeue a message from queue after a certain time
icon5.gif  Dequeue a message from queue after a certain time [message #314429] Wed, 16 April 2008 12:04
suksar
Messages: 9
Registered: February 2008
Junior Member
Hi all,
I am new in oracle advanced queue . My database version is Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi. I have a queue table and a queue on that table. I am putting a message on that queue and if the message is in the queue for 6 hours then it will call a pl/sql block and will send a notification via mail . Can any one please suggest , is there any such feature in oracle AQ ?

Regards,
Suksar

[Updated on: Wed, 16 April 2008 23:49]

Report message to a moderator

Previous Topic: MGW agent can't start
Next Topic: Propagating only the required data to destination
Goto Forum:
  


Current Time: Thu Mar 28 17:57:44 CDT 2024