Devart Forums

The version ODAC NET 6.80.0.47 with D2009, ParamByName('x').AsInteger doesn't work anymore!

The version ODAC NET 6.70.05.45 with BDS 2005 is working fine.

Here is the code:

OraQuery.sql := 'Insert into MY_SCHEMA.MY_TABLE (MY_INT)
Values (:MY_INT)';

OraQuery.ParamByName('MY_INT').AsInteger := 0;
OraQuery.prepare;
OraQuery.execsql;

=> exception class EInternalError with message
EOraError with message 'ORA-01438: value larger than specified precision allowed for this colimn'.

In Oracle this attribute is defined as Date and the same code works fine with BD2005 and your version 8.70.

thanks
michel

I got also an error with the

oraQuery.ParamByName('MY_TIME').asTime := MyTTime;
oraQuery.prepare;
oraQuery.execsql;

=> EOraError with message 'ORA-01483: invalid length for DATE or NUMBER bind variable'.

Hint:

it works fine when orasassion.Options.Direct := false,
but NOT when oraSession.Options.Direct := true; which is the mode we must use.

We have fixed this problem. The fix will be included in the next build of ODAC.

I downloaded the build 6.80.48 and it dtill does not work!
Are you sure you have tested the '.astime' and in NET Mode?

The version 6.80.0.48 was released before the fix. The fix will be included in the next ODAC build.