OraFAQ Forum: Streams & AQ » Oracle Advanced Queuing

Home » Server Options » Streams & AQ » Oracle Advanced Queuing

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Advanced Queuing [message #145465]

Thu, 03 November 2005 06:00

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!

Report message to a moderator

Re: Oracle Advanced Queuing [message #146222 is a reply to message #145465]

Wed, 09 November 2005 07:41

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 12:35:46 CST 2024