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