My Oracle Support Banner

Custom DB Trigger On Base Table (Doc ID 2589736.1)

Last updated on SEPTEMBER 23, 2023

Applies to:

Oracle Application Object Library - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


We have an outbound interface with a third party application for which we need to send real time data when a record is created or updated on the base table. When there are no Business Events to leverage to meet the business requirements can we use DB triggers instead?

For instance, when a record is created or updated in the table WIP.WIP_DISCRETE_JOBS can we create a trigger such that it inserts the unique key data into a custom table.


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.