E-PC: SQLExec SELECT Returning " " (space character) instead of returning "" (empty string) for Character fields (Doc ID 2111019.1)

Last updated on MARCH 08, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.51 to 8.53 [Release 8.4]
Information in this document applies to any platform.

Symptoms

If a Character field column's value is a single space character " ", and SQLExec executes a SELECT on that value for return, the returned parameter value is a " " space character.

This goes against PeopleBooks' description of SQLExec which says SQLExec will trim all leading spaces.

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