ODP AQ: Enqueueing or Dequeueing a Message With the Default Visibility Options Does not Enqueue the Message (Doc ID 835680.1)

Last updated on JUNE 27, 2011

Applies to:

Oracle Data Provider for .NET - Version: 11.1.0.7.10 and later   [Release: and later ]

Symptoms

Enqueueing or Dequeueing a message with the default visibility options of oncommit does not enqueue or dequeue the message. After execution of the following code, the Q table is empty.

// Create and open the connection 
   string constr = "user id=scott;password=tiger;data source=11gr1"; 
   OracleConnection con = new OracleConnection(constr); 
   con.Open(); 

// Prepare queue 
   OracleAQQueue queue = new OracleAQQueue("scott.testcommit_q", con); 
   queue.MessageType = OracleAQMessageType.Raw; 

// Prepare message and RAW payload 
   OracleAQMessage enqMsg = new OracleAQMessage(); 
   byte[] bytePayload = { 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 }; 
   enqMsg.Payload = bytePayload; 

// Enqueue message 
   queue.Enqueue(enqMsg); 




SQL> select count(*) from testcommit_q_tab;

COUNT(*)
----------
0

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms