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:

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

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