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

Last updated on JULY 20, 2024

Applies to:

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

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