Formatting still Incorrect even after Setting CURSOR_SHARING=EXACT
Last updated on MAY 31, 2017
Applies to:SQL*Plus - Version 22.214.171.124 and later
Information in this document applies to any platform.
You have multiple databases, each set with CURSOR_SHARING=EXACT; however, the formatting is incorrect only on one database when using SUBSTR, LPAD, RPAD, or TO_CHAR functions.
In all the databases, the expression "substr(host_name,1,16)" produces length 16, but in the "problem" database, it is length 48.
The databases are all on the same machine using the same software.
You upgraded the database version to later release.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms