I have found a nice information in oracle Support: Trigger Execution Sequence in Oracle Forms (Doc ID 61675.1)
Action |
Trigger Firing Order |
Level |
---|---|---|
Runform | 1. Pre-Logon | Form |
2. On-Logon | Form | |
3. Post-Logon | Form | |
4. Pre-Form | Form | |
5. When-Create-Record | Block | |
6. Pre-Block | Block | |
7. Pre-Record | Block | |
8. Pre-Text-Item | Item | |
9. When-New-Form-Instance | Form | |
10. When-New-Block-Instance | Block | |
11. When-New-Record-Instance | Block | |
12. When-New-Item-Instance | Item | |
Action |
Trigger Firing Order |
Level |
Enter Query | 1. Post-Text-Item | Item |
2. Post-Record | Block | |
3. When-Clear-Block | Block | |
4. When-New-Record-Instance | Block | |
5. When-New-Item-Instance | Item | |
Action |
Trigger Firing Order |
Level |
Execute Query After Enter Query |
1. Pre-Query | Block |
2. Pre-Select | Block | |
3. On-Select | Block | |
4. When-Clear-Block | Block | |
5. Post-Select | Block | |
6. On-Fetch | Block | |
7. On-Close | Form | |
8. When-Clear-Block | Block | |
Action |
Trigger Firing Order |
Level |
Execute Query Without Enter Query |
1. Post-Text-Item | Block |
2. Pre-Query | Block | |
3. Pre-Select | Block | |
4. On-Select | Block | |
5. Post-Select | Block | |
6. On-Fetch | Block | |
7. On-Close | Form | |
8. When_Create_Record | Block | |
9. Pre-Record | Block | |
10. Pre-Text-Item | Item | |
11. When-New-Record-Instance | Block | |
12. When-New-Item-Instance | Item | |
Action |
Trigger Firing Order |
Level |
Exit | 1. Post-Text-Item | Item |
2. Post-Record | Block | |
3. Post-Block | Block | |
4. Post-Form | Form | |
5. On-Rollback | Form | |
6. Pre-Logout | Form | |
7. On-Logout | Form | |
8. Post-Logout | Form | |
Action |
Trigger Firing Order |
Level |
Next Field and Previous field |
1. When-New-Item-Instance | Item |
Action |
Trigger Firing Order |
Level |
Next Record and Previous Record |
1. When-New-Record-Instance | Block |
2. When-New-Item-Instance | Item | |
Action |
Trigger Firing Order |
Level |
Next Block and Previous Block |
1. Post-Text-Item | Item |
2. Post-Record | Block | |
3. Post-Block | Block | |
4. When-Create-Record | Block | |
5. Pre-Block | Block | |
6. Pre-Record | Block | |
7. Pre-Text-Item | Block | |
8. When-New-Block-Instance | Block | |
9. When-New-Record-Instance | Block | |
10. When-New-Item-Instance | Form | |
Action |
Trigger Firing Order |
Level |
Records Are Queried | 1. Post-Query | Block |
2. Post-Change | Block | |
3. Post-Change | Item | |
4. Post-Change | Block | |
5. Post-Change | Block | |
Action |
Trigger Firing Order |
Level |
Go back to Post-Query | ||
Action |
Trigger Firing Order |
Level |
No Records Are Queried | 1. When-New-Record-Instance | Block |
2. When-New-Item-Instance | Item | |
Action |
Trigger Firing Order |
Level |
Create Record | 1. Post-Change | Block |
2. When-Validate-Item | Block | |
3. Post-Text-Item | Block | |
4. When-Validate-Record | Block | |
5. Post-Record | Block | |
6. Post-Block | Block | |
7. On-Savepoint | Form | |
8. Pre-Commit | Form | |
9. Pre-Insert | Block | |
10. On-Insert | Form | |
11. Post-Insert | Block | |
12. Post-Forms-Commit | Form | |
13. On-Commit | Form | |
14. Post-Database-Commit | Form | |
15. Pre-Block | Block | |
16. Pre-Record | Block | |
17. Pre-Text-Item | Block | |
18. When-New-Item-Instance | Form | |
Action |
Trigger Firing Order |
Level |
Update Record | 1. When-Database-Record | Block |
2. Post-Change | Block | |
3. When-Validate-Item | Block | |
4. Post-Text-Item | Block | |
5. When-Validate-Record | Block | |
6. Post-Record | Block | |
7. Post-Block | Block | |
8. On-Savepoint | Form | |
9. Pre-Commit | Form | |
10. Pre-Update | Block | |
11. On-Update | Block | |
12. Post-Update | Block | |
13. Post-Forms-Commit | Form | |
14. On-Commit | Form | |
Action |
Trigger Firing Order |
Level |
Delete Record | 1. On-Lock | Block |
2. When-Remove-Record | Block | |
3. Post-Change | Block | |
4. Post-Change | Block | |
5. Post-Change | Block | |
6. Post-Change | Block | |
7. Post-Change | Block | |
8. Post-Change | Block | |
9. Post-Change | Item | |
10. Post-Query | Block | |
11. Post-Text-Item | Block | |
12. Post-Record | Block | |
13. Pre-Record | Block | |
14. Pre-Text-Item | Block | |
15. When-New-Record-Instance | Block | |
16. When-New-Item-Instance | Form |
Die Kommentarfunktion ist geschlossen.