Numeric field as integer [ODBC131]
firebird-automations opened this issue · 5 comments
Submitted by: Everton Lucas (evtlucas)
I'm working in a project which I need to transfer some data from a firebird database to an oracle database. I'm using ODBC and Oracle Heterogeneous Services to connect in firebird from pl/sql procedures and functions.
When I'm reading numeric fields, the data inside these fields is returned as integer. (e.g. 812,43 returns as 812). The only way I can read the data correctly is dividing it by 100 and multiplying by 100 again. But when I need to use these one in a function(e.g. SUM), it returns as integer again, even when I perform the divide/multiply.
Commented by: @alexpotapchenko
It is more similar to a bug in Oracle.. Do you know way to reproduce it without Oracle?
The construction - sum ( CAST(field as float) ) can not help?
Commented by: Everton Lucas (evtlucas)
Maybe. Do you have some tip about how could I test if this bug is in Oracle or ODBC driver?
Commented by: @alexpotapchenko
I want to look at the ODBC trace log when you execute the query such as - "select numeric_field from table"
Modified by: @alexpotapchenko
status: Open [ 1 ] => Resolved [ 5 ]
resolution: Cannot Reproduce [ 5 ]
Fix Version: 2.0.1 [ 10430 ]
Modified by: @alexpotapchenko
status: Resolved [ 5 ] => Closed [ 6 ]