Formatting still Incorrect even after Setting CURSOR_SHARING=EXACT (Doc ID 462520.1)

Last updated on MAY 31, 2017

Applies to:

SQL*Plus - Version 8.1.7.0 and later
Information in this document applies to any platform.

Symptoms

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.

Changes

You upgraded the database version to later release.

Cause

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