My Oracle Support Banner

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: and later   [Release: 11.2 and later ]
Information in this document applies to any platform.


After upgrading the current production environment from Oracle 9i to Oracle or 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 or environment the result is a length of 4000.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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