You might encounter the following issues when using SAS/ACCESS^® Interface to Oracle:

• Oracle double-precision float values are not rounded correctly with Oracle server 12c or later. This issue occurs because the LIBNAME option OR_BINARY_DOUBLE=YES is not applied when you specify it. Since the default value for this option is YES, the option is never applied.
• 16-digit integers are not inserted correctly into the database.

Click the Hot Fix tab in this note to access the hot fix for this issue.

After you apply the hot fix, the LIBNAME option OR_BINARY_DOUBLE=YES is correctly applied when you explicitly specify it. Note that, because of possible complications with the YES setting for this option, the default value for the option is NO. The default behavior for this option is the same even if you do not install the hot fix.

Operating System and Release Information

A fix for this issue for SAS/ACCESS Interface to Oracle 9.45 is available at: