CAST NULL AS NUMBER(9) problem

CAST NULL AS NUMBER(9) problem

Postby amacchi » Mon 14 Apr 2008 10:29

We are using DbexpOda.dll Version 3.2.0.9
with those parameters:

EnableBCD = False
IntegerPrecision = 9
SmallIntPrecision = 0
FloatPrecision = 38

Every NUMBER(9) fields are correctly mapped as TIntegereField.
We want to map a View with NULL value for a column and map it as Integer Field.

CREATE VIEW MYVIEW (MyField1, MyField2) AS
SELECT
CAST(NULL AS NUMBER(9)) ,
CAST(0 AS NUMBER(9))
FROM
MYTABLE

MyField1 Will be wrong mapped as TFloatField.
MyField2 Will be correctly mapped as TIntegerField.

Why?

THX
Andrea
amacchi
 
Posts: 2
Joined: Mon 14 Apr 2008 10:16

Postby Plash » Tue 15 Apr 2008 08:09

This is an Oracle bug. Precision for this field is not returned correctly.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

Documentation

Postby amacchi » Tue 15 Apr 2008 09:42

Could you please send me link of official oracle article/documentation about this bug, please?
THX
amacchi
 
Posts: 2
Joined: Mon 14 Apr 2008 10:16


Return to dbExpress driver for Oracle