E-PC: SQLExec SELECT Returning " " (space character) instead of returning "" (empty string) for Character fields
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms