Oracle AQ EnqueueTime not correctly available

[Leonardo-Ferreira]

I'm dequeuing messages from my oracle AQ but the property "EnqueueTime" does not have the milliseconds portion of it! How can I retrieve it?

[alexkeh]

EnqueueTime returns a DateTime type. It should include a placeholder for milliseconds. Is the issue that the milliseconds placeholder contains just zeros?

Is this question about unmanaged, managed, or core ODP.NET? Which ODP.NET version?

[Leonardo-Ferreira]

Hello @alexkeh, thanks for the interest.

The issue is that the milliseconds part is always zero.

I'm using Oracle.ManagedDataAccess.Core v23.7.0

[alexkeh]

The ODP.NET dev team did some more research into this question. The DB AQ enqueue time granularity is in seconds only. Thus, ODP.NET cannot provide the millisecond information since the DB doesn't provide it.

Once the DB provides millisecond data, ODP.NET AQ should act as a passthrough and be able to return it.

[Leonardo-Ferreira]

@alexkeh, but the DB has a timestamp column with 9 digits precision:

https://docs.oracle.com/en/database/oracle/oracle-database/19/adque/aq-messaging-gateway-views.html#GUID-78CC1D99-D2DD-4B80-BC38-4BBF39E05EFA

[alexkeh]

@Leonardo-Ferreira
I see. ODP.NET supports the ENQ_TIME, but not the ENQ_TIMESTAMP. I've filed ER 37767276 to track this request. ODP.NET would probably provide a second enqueue time property for the millisecond granularity.

Can you provide a short business case on the need and urgency for the feature? I'll add the info to the ER.