E-ORA Create Oracle Database Trigger to Manipulate the Session Associated with a PeopleSoft Batch Process
(Doc ID 1415642.1)
Last updated on NOVEMBER 23, 2019
PeopleSoft Enterprise PT PeopleTools - Version 8.44 to 8.52 [Release 8.4] Information in this document applies to any platform.
***Checked for relevance on 07-Aug-2013***
***Checked for relevance on 08-June 2017***
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!