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,
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@xxxxxxxxxxxxxxxxxxxx
**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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
