Erro ZeosLib 6.6.6., with Oracle 10g + Delphi 7

[JavaPauloMG]

Hello my friends,

I found a error when i execute a simple SQL statement in a TZQuery:

Code: Select all

select current_timestamp from dual

The error is "invalid argument to time encode", i comment this line in code, and this pass correct.

It can be a propertie from ZConnection to Oracle? The ZeosLib work's fine in Oracle 10.g?

Thanks to all.

[JavaPauloMG]

The error appers related to miliseconds convert, i do a convert in statement and now it's work, the question is how to correct the error to all users?

Code: Select all

select TO_TIMESTAMP(TO_CHAR(current_timestamp, 'DD-MM-YYYY HH24:MI:SS'), 'DD-MM-YYYY HH24:MI:SS') from dual

The inspiration to this correction is from this page, he makes the correction direct in code in of ZeosLib.

http://zeosbugs.firmos.at/view.php?id=116

[mdaems]

Can you try to fix the TZOracleResultSet.GetAsDateTimeValue function to convert correctly without exceptions?

Mark