My Oracle Support Banner

Returning Different Value When Using Oracle Sybase Gateway (Doc ID 2892122.1)

Last updated on AUGUST 25, 2022

Applies to:

Oracle Database Gateway for Sybase - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Using the datatype float(16) for floating number in Sybase.

The value in Sybase is “623.7364502270076”, but when using Oracle Database Gateway for Sybase to select into Oracle database, the value becomes “623.736450227008”.

The Database Gateway does some rounding instead of copying the extract value from Sybase, which caused the database gateway query result different from the source.

Sybase table column data type - <col_name> Float(16)

Sybase select result -

select <col_name> from <table_name> where <col_name>='2019-11-04' and <col_name>='XXX' and <col_name>='Y'
623.7364502270076

Oracle select result using Database Gateway for Sybase -

SELECT "<col_name>" FROM "<table_name"@DBLINK where "<col_name>"='04Nov2019' and "<col_name>"='XXX' and "<col_name"='Y';
623.736450227008 (auto round up)

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.