Trigger Execution Sequence in Oracle Forms
来源:互联网 发布:sql 修改字段属性 编辑:程序博客网 时间:2024/06/05 02:10
Introduction
This document lists the order in which triggers fire in Oracle Forms 4.5: o The first column, Action, describes the function to be performed (e.g. deleting a record). o The second column, Trigger Firing Order, describes the order in which triggers fire after a function is performed. o The third column, Level, describes the level (form, block, item) at which the trigger fires. This was accomplished by creating a form with all the triggers invoked. If a trigger could fire at all levels, it was included at all levels. Such a trigger fires at the lowest level at which it is defined.Key triggers and triggers which fire via buttons or check boxes arenot included.This bulletin does not cover every contingency and covers only themost commonly used actions.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***********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 ItemNote: If you define the Key-ENTQRY trigger, this is the only trigger which fires in an Enter Query situation.*****************Execute QueryAfter 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 BlockNote: If you define the Key-EXEQRY trigger, this is the only trigger which fires in an Execute Query situation.*************Execute QueryWithout EnterQuery 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****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**************Next Field andPrevious field 1. When-New-Item-Instance Item***************Next Record andPrevious Record 1. When-New-Record-Instance Block 2. When-New-Item-Instance Item**************Next Block andPrevious 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*******************Records Are Queried 1. Post-Query Block 2. Post-Change Block 3. Post-Change Item 4. Post-Change Block 5. Post-Change Block Go back to Post-QueryNOTE: This cycle is repeated for each record retrieved.**********************No Records Are Queried 1. When-New-Record-Instance Block 2. When-New-Item-Instance ItemNOTE: To observe this Trigger Firing Order: a. Enter a query. b. Enter a nonexistent record. c. Execute the query. The two triggers listed above, the Enter Query triggers, and the Execute Query triggers fire.*************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*************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 Here the transaction is complete and one record added. 15. Post-Database-Commit Form 16. Pre-Text-Item Block 17. When-New-Item-Instance FormNOTE: To observe this Trigger Firing Order: a. Execute a query. b. Change a value. c. Choose Action->Save from the menu. d. Record the triggers from that point.*************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 FormNOTE: To observe this Trigger Firing Order, delete a detail record.
Reference: (Doc ID 61675.1)
- Trigger Execution Sequence in Oracle Forms
- Trigger Execution Sequence in Forms 4.5
- (V45) Trigger Execution Sequence in Forms 4.5
- Forms trigger Firing Sequence
- Oracle create trigger and sequence
- Oracle Forms开发之触发器(trigger)
- Trigger in oracle
- Triggers in Oracle Forms
- oracle创建trigger procedure function sequence plsql
- oracle创建sequence和触发器trigger
- SQL Query execution sequence in WHERE clause
- Sequence Trigger
- Sequence in Oracle DB
- oracle中sequence trigger 及构造自增长字段
- oracle中利用trigger,sequence自动生成ID
- oracle 没有autoincrement,使用sequence和trigger实现自增
- sql: Oracle 11g create table, function,trigger, sequence
- sql: Oracle 11g create table, function,trigger, sequence
- 关于刷新html页面,数据重复提交的问题
- B树、B-树、B+树、B*树
- 从不同节点提交 pbs job
- wordpress关于rss订阅同步到各微博问题
- Xcode 遇到的问题
- Trigger Execution Sequence in Oracle Forms
- 享受寂寞
- awk 获取ip地址的学习
- perl对于utf8编码文件的substr
- C#二分法
- Linux内核--网络协议栈深入分析(三)--BSD socket和传输层sock
- spring MVC 3.1.1 + Mybatis 3.1.1 WebSphere 7.0 发布
- Migrating Queries from One User To Another
- HDU 1253 3维bfs 一直wa,原来是小错误。