CAST NULL AS NUMBER(9) problem

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
amacchi
Posts: 2
Joined: Mon 14 Apr 2008 10:16

CAST NULL AS NUMBER(9) problem

Post by 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

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Tue 15 Apr 2008 08:09

This is an Oracle bug. Precision for this field is not returned correctly.

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

Documentation

Post by amacchi » Tue 15 Apr 2008 09:42

Could you please send me link of official oracle article/documentation about this bug, please?
THX

Post Reply