E-PC: SQLExec SELECT Returning " " (space character) instead of returning "" (empty string) for Character fields
(Doc ID 2111019.1)
Last updated on JANUARY 03, 2023
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
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
Symptoms |
Cause |
Solution |
References |