Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Continuous notifications and foreign keys

ivansmSep 29 2015 — edited Sep 29 2015

Hallo. I am using database event notification and I noticed the following: wherever a table is modified which has foreign key associations with other tables, then I receive the notification for the table itself (with proper operation code) and for notifications with opcode 0x41 (OCI_OPCODE_UNKNOWN + OCI_OPCODE_ALLROWS) for all tables that have foreign key relationship with first one, both when secondary tables refer to the columns in the first table as foreign keys and when first table uses field from other tables as foreign key. Is there any opportunity to determine whether the notification is sent just because of foreign key or due to some other reason? Is there any kind of log on database server side where I can review what kind of notifications were sent and for what reason?


Best regards

Comments

Jerry S.

Update: Just in case anyone has this question in the future.

I did some experimentation and the CEO record needs to have a null value in its parent key field in the

original data table before the scripts are run to build and populate the parent-child relationship table.

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 27 2015
Added on Sep 29 2015
0 comments
389 views