AQ dequeue question

From: rjamya <rjamya_at_gmail.com>
Date: Thu, 25 May 2006 15:32:20 -0400
Message-ID: <9177895d0605251232y2c6b3adbo30134c47a791a937@mail.gmail.com>

We have a process that tracks changes to a table, whenever a column is changes, pk is inserted in a AQ. There is a daemon process that does some processing based on this value.

It may happen that in a short burst, one row may get modified multiple times. Now we want to avoid re-processing the same row based on entries in AQ.

Is there a way to get a ordered (rather distinct) set for dequeue by specifying an attribute in the USERDATA part of the payload when dequeuing?

Oracle is 9.2

TIA
Raj

---

Got RAC?
--

http://www.freelists.org/webpage/oracle-l Received on Thu May 25 2006 - 14:32:20 CDT