Hi,
I am trying to consume a queue where the user_data field is using SYS.XMLTYPE.
Whenever I try to Dequeue a message I get an instance of OracleAQMessage with the metadata but the payload is null.
I've checked the values in the database and there is a XML in the user_data field.
How can I read this value?
I already tried creating an instance of the queue like this:
OracleAQQueue("APPUSER.XML_QUEUE", conn, OracleAQMessageType.Xml)
If I try RAW it gives me an exception. If I don't set the Xml, I also get an exception.
I have also tried to map the SYS.XMLTYPE as an UDT but I get the same result.
Recently, I am trying to debug this situation using Docker. I've built an instance of Oracle Enterprise in my localhost but whenever I try to Dequeue a message, I get an exception:
Oracle.ManagedDataAccess.Client.OracleException: 'ORA-12537: TNS:connection closed
When I look inside the logs of the container I get this message:
ORCLPDB1(3):Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x3C] [PC:0x14BDB8A5, ktcsna()+69] [flags: 0x0, count: 1]
Errors in file /opt/oracle/diag/rdbms/orclcdb/ORCLCDB/trace/ORCLCDB_ora_8602.trc (incident=62764) (PDBNAME=ORCLPDB1):
ORA-07445: exception encountered: core dump [ktcsna()+69] [SIGSEGV] [ADDR:0x3C] [PC:0x14BDB8A5] [Address not mapped to object] []
ORCLPDB1(3):Incident details in: /opt/oracle/diag/rdbms/orclcdb/ORCLCDB/incident/incdir_62764/ORCLCDB_ora_8602_i62764.trc
ORCLPDB1(3):Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2025-04-28T02:09:19.815941+00:00
Dumping diagnostic data in directory=[cdmp_20250428020919], requested by (instance=1, osid=8602), summary=[incident=62764].
This does not happens on my company's envs.