Page 1 of 1

OracleQueueMessage :: ObjectPayload is null sometimes

Posted: Mon 13 Jul 2020 15:02
by Amod
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?

Re: OracleQueueMessage :: ObjectPayload is null sometimes

Posted: Tue 14 Jul 2020 18:31
by Shalex
Please localize the issue in a test project and send it to us with the corresponding DDL/DML script via contact form.