My Oracle Support Banner

E-ORA: Using USELOCALORACLEDB=1 Option have Different Behavior for Trim Using GetSQL Function with Fetch Method (Doc ID 2807281.1)

Last updated on SEPTEMBER 15, 2021

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.58 and later
Information in this document applies to any platform.


While fetching a SQL definition in Peoplecode, the behavior is different in the same SQL, on returned string value: one that trim the result and the other that doesn't trim the result.

The issue can be reproduced at will with the following steps:

1. Created a dummy table

4. In PIA from root > PeipleTools > Process Scheduler > System Process Requests - run the AEMINITEST
Output: VARCHAR2(30 CHAR) space:() and VARCHAR2(128 CHAR) space:() (0,0)

5. Check psprcs.cfg - it has UseLocalOracleDB=0

6. Change to UseLocalOracleDB=1

7. Restart process scheduler server

8. rerun the AEMINITEST and observe the issue





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

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