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