Forum Stats

  • 3,815,879 Users
  • 2,259,111 Discussions
  • 7,893,299 Comments

Discussions

OCIAQDeq fails to deque existing messages

3004
3004 Member Posts: 204,171 Green Ribbon
Environment:
Oracle Server 8.1.6 WinNT
Oracle Client 8.1.7 WinNT
point-to-point queue
AQDEQ options:
DEQ_MODE = OCI_DEQ_REMOVE
VISIBILITY = OCI_DEQ_ON_COMMIT
WAIT = OCI_DEQ_WAIT_FOREVER
Problem:
Sometimes the queue consumer application blocks on OCIAQDeq when there is an existing message in the queue or a message has just been enqued.
However , if another message is enqued , OCIAQDeq returns both the first and the second message.
I never observed this with more than one message.

Comments

This discussion has been closed.