How to read DateTimeOffset from OracleArrayDataReader

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
pakarjon
Posts: 6
Joined: Tue 05 Mar 2019 13:22

How to read DateTimeOffset from OracleArrayDataReader

Post by pakarjon » Mon 25 Mar 2019 08:49

OracleDataReader has "GetDateTimeOffset" -method to retrieve timestamp from data.

OracleArrayDataReader however does not have similar method and that's the reader I get when reading nested table data from object view.

How should I handle timestamp value reading with OracleArrayDataReader?

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: How to read DateTimeOffset from OracleArrayDataReader

Post by Pinturiccio » Mon 25 Mar 2019 13:07

Yes, OracleArrayDataReader does not have the GetDateTimeOffset method. We will investigate the possibility to implement this method and post here when we get the results.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: How to read DateTimeOffset from OracleArrayDataReader

Post by Pinturiccio » Wed 27 Mar 2019 13:54

We have added GetOracleTimeStamp, GetDateTimeOffset, and GetTimeSpan methods to OracleArrayDataReader. We have also fixed some bugs with reading data via OracleArrayDataReader. We will post here when the corresponding build of dotConnect for Oracle is available for download.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: How to read DateTimeOffset from OracleArrayDataReader

Post by Pinturiccio » Fri 29 Mar 2019 11:07

New build of dotConnect for Oracle 9.6.725 is available for download.
It can be downloaded from https://www.devart.com/dotconnect/oracle/download.html (trial version) or from Customer Portal (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=38518

Post Reply