Picking a message from OAQ

CP Jan 26, 2013 3:36 AM

Currently Being Moderated

Message will be enqueued in OAQ by some process. Need to pick this message from that Queue whenever message is dropped. Will DBMS SCHEDULER package help in picking up this message. Cannot specify the interaval in that package. If not how can we pick the message?

1. Re: Picking a message from OAQ

Etbin Jan 26, 2013 3:46 AM (in response to CP)

Currently Being Moderated

You might be better off posting to {forum:id=66}

Regards

Etbin
Report Abuse

Like (0)
2. Re: Picking a message from OAQ

CP Jan 26, 2013 4:01 AM (in response to Etbin)

Currently Being Moderated

Thanks Etbin. Didn't no we have a separate forum for this.
Report Abuse

Like (0)
3. Re: Picking a message from OAQ

Richard Harrison . Jan 26, 2013 1:16 PM (in response to CP)

Currently Being Moderated

Hi,
No need for dbms_scheduler. Just google for plsql callback (or callbacks generally) and the dbms_aq.register procedure. That should be all you need. Essentially creates a trigger on the queue.

Cheers,
Harry
Report Abuse

Like (0)

Go to original post

Actions

Legend

Correct Answers - 10 points
Helpful Answers - 5 points