Issue Details (XML | Word | Printable)

Key: ODBC-131
Type: Bug Bug
Status: Closed Closed
Resolution: Cannot Reproduce
Priority: Major Major
Assignee: Alexander Potapchenko
Reporter: Everton Lucas
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.
ODBC Driver

Numeric field as integer

Created: 12/Aug/11 08:29 PM   Updated: 31/May/12 03:29 PM
Component/s: None
Affects Version/s: 2.0
Fix Version/s: 2.0.1

Environment: Windows 7

 Description  « Hide
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.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alexander Potapchenko added a comment - 13/Aug/11 09:24 AM
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?

Everton Lucas added a comment - 15/Aug/11 05:31 PM
Maybe. Do you have some tip about how could I test if this bug is in Oracle or ODBC driver?

Alexander Potapchenko added a comment - 15/Aug/11 05:43 PM
I want to look at the ODBC trace log when you execute the query such as - "select numeric_field from table"