Delete from a queue table?

  • From: "Stauffer, Robert G" <rstauffer@xxxxxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 21 Jan 2005 15:54:17 -0500

Hi all,, AIX 5.2

One of our developers is writing an app using Advanced Queuing.  As a
DBA, I'm trying to help him through some issues, but we're both AQ
novices.  The documentation and examples can be a little confusing for
the newbie.

The app is designed to leave a message in the queue table after it has
been dequeued.  That design was chosen so that the data can be queried
for history/statistics.

It turns out that there are times that a message needs to be removed
from the queue table after it's been dequeued and re-enqueued so that it
can be processed again.  Any suggestions on how to remove it from the
queue table?  Can it just be deleted from the queue table?

Bob Stauffer
D&E Communications
Ephrata, PA, USA

This e-mail message and any files transmitted with it are intended for the =
use of the individual or entity to which they are addressed and may contain=
 information that is privileged, proprietary and confidential. If you are n=
ot the intended recipient, you may not use, copy or disclose to anyone the =
message or any information contained in the message. If you have received t=
his communication in error, please notify the sender and delete this e-mail=
 message. The contents do not represent the opinion of D&E except to the ex=
tent that it relates to their official business.

Other related posts: