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
nicoleta
Messages: 2
Registered: November 2005
Junior Member
Hello!
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!
10q!
Re: Oracle Advanced Queuing [message #146222 is a reply to message #145465] Wed, 09 November 2005 07:41 Go to previous message
sanju.sinha@gmail.com
Messages: 30
Registered: November 2005
Member

Hi,
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.

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


Current Time: Thu Mar 28 07:56:40 CDT 2024