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 laterInformation in this document applies to any platform.
Symptoms
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
Changes
N/A
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 |
| Changes |
| Cause |
| Solution |
| References |