文档下载 文档下载导航
设为首页 | 加入收藏
搜索 请输入内容:  
 导航当前位置: 文档下载 > 所有分类 > IT/计算机 > Trigger Execution Sequence in Oracle Forms
侵权投诉

Trigger Execution Sequence in Oracle Forms

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.

第1页

你可能喜欢

热门文档

相关文档

  • Oracle之Forms开发指南--触发器段

    Oracle之Forms开发指南--触发器段_计算机软件及应用_IT/计算机_专业资料。... Trigger Execution Sequ... 6页 免费 oracle触发器 1页 免费...

  • oracle sequence 使用方法

    oracle sequence 使用方法_IT/计算机_专业资料。oracle sequence 使用方法create sequence 在 oracle 中 sequence 就是所谓的序列号,每次取的时候它会自动增加,一般...

  • ORACLE ERP开发之OracleForms基础

    ORACLE ERP开发之OracleForms基础_IT/计算机_专业...而且此字段一般不让用户操作,由 sequence 自动维护。...3、解决方法: 3.1 避免在 TRIGGER 中直接使用 ...

  • ORACLE SEQUENCE的简单介绍(自增长字段)

    ORACLE SEQUENCE的简单介绍(自增长字段)_IT/计算机_专业资料。ORACLE SEQUENCE的... Trigger Execution Sequ... 6页 免费 在oracle中创建自增字段... 2页 免费...

  • Oracle的sequence主键

    在Hibernate 中使用 Oracle 的 sequence 主键在 Oracle 中建立 sequence,名称为 pk: create sequence pk start with 1 increment by 1 maxvalue 2000 nocycle ...

  • Oracle_Forms开发基础知识

    Oracle_Forms开发基础知识_IT/计算机_专业资料。Oracle_Forms开发基础知识...13 3.2.6 修改 Trigger 这两个 Trigger 一定要修改,否则你的 Form 不能...

  • Oracle_Forms开发常用技巧

    Oracle_Forms开发常用技巧_IT/计算机_专业资料。...(SQLERRM); RAISE FORM_TRIGGER_FAILURE; END; 2....DOC_SEQUENCE_VALUE、CURRENCY_CODE2、ENTERED_DR、 ...

  • oracle form 常用Trigger的触发时机

    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 不一致问题

    oracle RAC 环境解决sequence 不一致问题_计算机硬件及网络_IT/计算机_专业资料。oracle RAC 环境解决 sequence 不一致问题 Sequences in Oracle 10g RAC Just ...

  • 使用Trigger跟踪Oracle用户操作

    使用Trigger跟踪Oracle用户操作方法一: 用以下的方式可以监控登入登出的用户: 创建如下的两张表: create table login_log -- 登入登出信息表 ( session_id int ...

站点地图 | 文档上传 | 侵权投诉 | 手机版
本站所有资源均来自互联网,本站只负责收集和整理,均不承担任何法律责任,如有侵权等其它行为请联系我们.
文档下载 Copyright 2013 doc.guandang.net All Rights Reserved.  -  email