My Oracle Support Banner

Custom DB Trigger On Base Table (Doc ID 2589736.1)

Last updated on SEPTEMBER 18, 2019

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.

Goal

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.
 

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!


In this Document
Goal
Solution


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