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 and later
Information in this document applies to any platform.


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'

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)


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

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