Formatting still Incorrect even after Setting CURSOR_SHARING=EXACT
(Doc ID 462520.1)
Last updated on JUNE 02, 2021
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.
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