Home » Server Options » Streams & AQ » Oracle Advanced Queuing
icon9.gif  Oracle Advanced Queuing [message #145465] Thu, 03 November 2005 06:00 Go to next message
Messages: 2
Registered: November 2005
Junior Member
Let's suppose we have a queue and we need to retrieve the IDs of the messages in that queue. Is there an OCI function that can retrieve the ID of a message from that queue without dequeuing the message from the queue? (I mean except for OCIAQDequeue, which indeed returns the ID of the dequeued message).
I'm kind of new to OCI progamming, so if anybody could help me, I'd appreciate it a lot!
Re: Oracle Advanced Queuing [message #146222 is a reply to message #145465] Wed, 09 November 2005 07:41 Go to previous message
Messages: 30
Registered: November 2005

I do not know about OCI programming but you can query the AQ table using SQL. You can use -

SELECT msgid from <Q Table Name>;

See if you can embed it in your OCI program.

Previous Topic: Oracle Streams to Flat file or named pipe
Next Topic: Queue Monitor
Goto Forum:

Current Time: Thu Mar 30 16:32:18 CDT 2023