My Oracle Support Banner

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. *** ***


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!

In this Document
 Basic Approach
 Naming Triggers
 Required Grant
 Identifying Existing Triggers
 Dropping Triggers
 Special Considerations

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