Trigger Execution Sequence in Oracle Forms
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 are not included.
This bulletin does not cover every contingency and covers only the most commonly used actions.
Action Trigger Firing Order Level
------ -------------------- -----
Run form
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 Item
Note: If you define the Key-ENTQRY trigger, this is the only trigger which fires in an Enter Query situation.
Oracle之Forms开发指南--触发器段_计算机软件及应用_IT/计算机_专业资料。... Trigger Execution Sequ... 6页 免费 oracle触发器 1页 免费...
oracle sequence 使用方法_IT/计算机_专业资料。oracle sequence 使用方法create sequence 在 oracle 中 sequence 就是所谓的序列号,每次取的时候它会自动增加,一般...
ORACLE ERP开发之OracleForms基础_IT/计算机_专业...而且此字段一般不让用户操作,由 sequence 自动维护。...3、解决方法: 3.1 避免在 TRIGGER 中直接使用 ...
ORACLE SEQUENCE的简单介绍(自增长字段)_IT/计算机_专业资料。ORACLE SEQUENCE的... Trigger Execution Sequ... 6页 免费 在oracle中创建自增字段... 2页 免费...
在Hibernate 中使用 Oracle 的 sequence 主键在 Oracle 中建立 sequence,名称为 pk: create sequence pk start with 1 increment by 1 maxvalue 2000 nocycle ...
Oracle_Forms开发基础知识_IT/计算机_专业资料。Oracle_Forms开发基础知识...13 3.2.6 修改 Trigger 这两个 Trigger 一定要修改,否则你的 Form 不能...
Oracle_Forms开发常用技巧_IT/计算机_专业资料。...(SQLERRM); RAISE FORM_TRIGGER_FAILURE; END; 2....DOC_SEQUENCE_VALUE、CURRENCY_CODE2、ENTERED_DR、 ...
Sequence Trigger 1 PRE-FORM Level Form WHEN-NEW-RECORD-INSTANCE Block WHEN... oracle FORM trigger执行... 6页 1下载券 Oracle+EBS+Forms开发指... 56...
oracle RAC 环境解决sequence 不一致问题_计算机硬件及网络_IT/计算机_专业资料。oracle RAC 环境解决 sequence 不一致问题 Sequences in Oracle 10g RAC Just ...
使用Trigger跟踪Oracle用户操作方法一: 用以下的方式可以监控登入登出的用户: 创建如下的两张表: create table login_log -- 登入登出信息表 ( session_id int ...
热门文档