OracleQueueMessage :: ObjectPayload is null sometimes

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Amod
Posts: 3
Joined: Thu 16 May 2019 09:59

OracleQueueMessage :: ObjectPayload is null sometimes

Post by Amod » Mon 13 Jul 2020 15:02

Devart.Data.Oracle - 9.11.980
Oracle client version - 12.2.0.1.0
Oracle server version - 12.2.0.1.0

https://www.devart.com/dotconnect/oracle/docs/AQ.html

Per the code sample

Code: Select all

OracleQueueMessage msg = oracleDequeueQueue.Dequeue();
if (msg != null && msg.ObjectPayload != null) {
  Console.WriteLine(msg.ObjectPayload["nickname"]);
  Console.WriteLine(msg.ObjectPayload["mestext"]);
}
In my application there are few times (rare but happens) when the ObjectPayload becomes null. How do I debug this on Devart side or Oracle side?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: OracleQueueMessage :: ObjectPayload is null sometimes

Post by Shalex » Tue 14 Jul 2020 18:31

Please localize the issue in a test project and send it to us with the corresponding DDL/DML script via contact form.

Post Reply