Newbie AQ question
581947Jun 7 2007 — edited Jun 8 2007Hey guys I'm playing with Oracle Advanced Queuing for a project. I've been reading up on it and playing with examples and I've found myself stuck now.
I want to create a simple point to point queue. Using the examples I've been able to create a queue and write code to enqueue and dequeue items. I have the code to dequeue items in a script. I run the script it dequeues an item, I run the script again it dequeues another item.
What do I need to do or setup so it's constantly monitoring the queue and automatically dequeuing items?
Any help or nudging in the right direction would be appreciated. Thanks.