Skip to Main Content
Forums

SQL & PL/SQL

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

compound triggers - order of compound timing point sections

user1688514Mar 17 2015 — edited Mar 19 2015

Hi,

I'm trying to understand what is the correct order of timing point sections in compound triggers.

In the documentation

http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/triggers.htm#LNPLS2006

it first says:

"Timing-point sections must appear in the order shown in Table 9-1. (...)

1.png

But then, in the example "Example 9-3 Compound Trigger Records Changes to One Table in Another Table" the order is : AFTER EACH ROW IS and then AFTER STATEMENT.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 16 2015
Added on Mar 17 2015
4 comments
1,318 views