PL/SQL (MOSC)

MOSC Banner

Looking for docs on the semantics of triggering statements (especially as related to Foreign Keys)

edited Jun 23, 2022 7:08PM in PL/SQL (MOSC) Question

Is there documentation on what exactly constitutes a triggering statement as used in https://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/plsql-triggers.html. Especially as to how the existence of foreign keys causes tables other than those directly affected to be triggered. Basically i have encountered some non-intuitive behavior that appears to be "by design" so i am looking for confirmation that this is the intended behavior, but have been unable to find anything on the subject.

We are using a compound trigger with a BEFORE STATEMENT to do some checks similar to the example in 9.3.4.7 https://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/plsql-triggers.html#GUID-9E6E59EF-F402-4B11-A4FF-268D9C0521EB

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center