E-ORA Create Oracle Database Trigger to Manipulate the Session Associated with a PeopleSoft Batch Process
(Doc ID 1415642.1)
Last updated on FEBRUARY 14, 2022
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.44 to 8.52 [Release 8.4] Information in this document applies to any platform.
*** ***
Goal
Occasionally it is beneficial to manipulate the Oracle session associated with a PeopleSoft batch process, e.g. to alter a session parameter or to enable a detailed SQL trace option. The purpose of this document is to explain a technique to do this using a database trigger.
Solution
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!