[go: up one dir, main page]
Scribd
Upload
118 views1 page

Oracle D2K Trigger Firing Sequence

The document discusses the trigger firing sequence in Oracle D2K forms. When a form is opened, logon triggers like pre-logon and post-logon are fired. Then pre-form and pre-block triggers are fired. Next, when-new triggers are fired at the form, block, and item levels. After this, item level triggers like key-next-item and post-change are fired as the user enters data and tabs between items. Finally, post triggers like post-block and post-form are fired when the form is closed.

Uploaded by

Anu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
118 views1 page

Oracle D2K Trigger Firing Sequence

The document discusses the trigger firing sequence in Oracle D2K forms. When a form is opened, logon triggers like pre-logon and post-logon are fired. Then pre-form and pre-block triggers are fired. Next, when-new triggers are fired at the form, block, and item levels. After this, item level triggers like key-next-item and post-change are fired as the user enters data and tabs between items. Finally, post triggers like post-block and post-form are fired when the form is closed.

Uploaded by

Anu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Trigger Firing sequence in D2K (Oracle Forms)

Trigger Firing sequence:


This is most important thing to understand in Oracle D2K Forms When you open a form
following triggers are executed

First Logon Triggers are fired


1.PRE-LOGON
2.ON-LOGON
3.POST-LOGON

After that Pre Triggers


4. PRE-FORM
5. PRE-BLOCK
6. PRE-TEXT

After that WHEN-NEW Triggers


7. WHEN-NEW-FORM-INSTANCE
8. WHEN-NEW-BLOCK-INSTANCE
9. WHEN-NEW-ITEM-INSTANCE

After that ITEM Level Triggers


After this focus is on the first item of the Block. If you type some data and press the tab key
following trigger will fire in sequence
10.KEY-NEXT-ITEM (This trigger is present on the item level).
11.POST-CHANGE (This trigger is present on the item level).
12.WHEN-VALIDATE-ITEM (This trigger is present on the item level).
13.POST-TEXT-ITEM (This trigger is present on the item level).
14.WHEN-NEW-ITEM-INSTANCE (Block Level Trigger).

Now focus will go the next item present on the form.


If there are no further items present on the screen them if we enter data and press tab key
then only KEY-NEXT-ITEM is fired. Now suppose we close the form then the item level
triggers are fired.

POST TRIGGERS

15.POST-BLOCK
16.POST-FORM

Now the form will be closed.

You might also like