Select LPAD Through OCI Gives Wrong Length Result (Doc ID 1401584.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.3 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms


After upgrading the current production environment from Oracle 9i to Oracle 11.2.0.2 or 11.2.0.3 a SQL SELECT returns a different length when using the LPAD function within an OCI 7 application.

Here is the SQL being executed using OCI:        "select lpad('abcd',6,'z') from dual"

Against an Oracle 9i environment the result is a length of 6.
Against an Oracle 11g 11.2.0.2 or 11.2.0.3 environment the result is a length of 4000.

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