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: 184.108.40.206
Information in this document applies to any platform.
After upgrading the current production environment from Oracle 9i to Oracle 220.127.116.11 or 18.104.22.168 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 22.214.171.124 or 126.96.36.199 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.|