Fields Types Mismatch

[Pascal-Ips]

Hello,
Delphi 10.3.1 + Doa 4.1.3.5
Oracle 11.2.0.1.0
Oci 11.1

I have fields in the database table declared Number(12,2)

Oracle dataset retreive persistents fields as StringField instead of FloatField

Can't understand Why ?

Fields declared Number(x,0) are well retreived as integer field

I didn't have this behaviour with D7 and Doa 4.0.7 (same database)

Can you help ?
Thanks
Pascal

 

[Marco Kalter]

Perhaps you have set TOracleSession.Preferences.FloatPrecision to 11 or less? Number fields with a larger precision will then be represented by a TStringField.

 

[Koushik]

HI I am trying to Connect Oracle 18c using DOA 4.0.7 from Delphi 6. Unfortunately I am getting ORA-12577 error. Can anyone help on the same?

 

[Marco Kalter]

Can you check if the Oracle18c bin directory is listed first in the PATH environment variable? Can you also check if the ORACLE_HOME environment variable is defined correctly?

 

[Pascal-Ips]

Thanks for reply

Yes : Floatprecision is set to 2
The field in database is declared Number(12,2)

No changes when floatprecision set back to 0
Field always retreive as string

What can i do ?
Thanks

 

[Pascal-Ips]

I delete my component OracleSession et drop it again from component palette et now it works

Thanks

Thanks for reply

Yes : Floatprecision is set to 2
The field in database is declared Number(12,2)

No changes when floatprecision set back to 0
Field always retreive as string

What can i do ?
Thanks