My Oracle Support Banner

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

Last updated on JULY 13, 2023

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

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
Symptoms
Changes
Cause
Solution
References

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