OraFAQ Forum: Streams & AQ » Dequeue a message from queue after a certain time

Home » Server Options » Streams & AQ » Dequeue a message from queue after a certain time

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 16:30:18 CST 2024