"Invalid argument to date encode." error

[wingtang]

We used ODAC 6.25 components
and linked them by following
TOraSession -> TOraQuery -> TOraProvider ->TClientDataSet->TDataSource -> TDBGrid
And we wrote a SQL that just selected one timestamp type field in the ClientDataSet,
after we opened the ClientDataSet, we got no record but a error message said "Invalid argument to date encode." Could you tell me what should we do to solve this problem?

Environment Setting:
Oracle 10g, Delphi 7 (with 7.1 Update), Oracle 10g client, Windows 2003 Server Standard Edition

[Plash]

TOraProvider or TDataSetProvider does not support TOraTimeStampField fields that are created for TIMESTAMP data type.

[wingtang]

TOraProvider or TDataSetProvider does not support TOraTimeStampField fields that are created for TIMESTAMP data type.

Thanks for replying, will the field type be support in the future version?

[Plash]

In the next ODAC build we'll add the EnableOraTimeStamp option to TOraSession. You need to set this option to False. In this case standard field type will be used instead of TOraTimeStampField, and your query will work with TDataSetProvider.

[Iliev]

I have the same problem with ODAC 8.15 and Delphi XE. It doesn't matter if I set EnableOraTimestamp property in TOraSession to true or false. First - TOraQuery always creates TOraTimeStampField and second - event when I manually replaced "TOraTimeStampField, {ftOraTimeStamp}" row with "TSQLTimeStampField, {ftOraTimeStamp}" in ODACFieldClasses array this error continued to happen.

[AlexP]

Hello,

Thank you for the information.
We have reproduced the problem.
We will try to fix it in the nearest product version.

[AlexP]

hello,

The new ODAC version 8.2.7 including this fix is already available at our site