Delete from a queue table?

From: Stauffer, Robert G <rstauffer_at_decommunications.com>
Date: Fri, 21 Jan 2005 15:54:17 -0500
Message-ID: <DBD57944BD147146A3FA5E66983322E40289665A@CL-EXCHANGE1.dande.com>

Hi all,

9.2.0.5, 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
DBA
D&E Communications
Ephrata, PA, USA
717-738-8737
rstauffer_at_decommunications.com

**DISCLAIMER

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.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jan 21 2005 - 17:00:48 CST