Oracle form trigger execution sequence

Oracle form trigger execution sequence ()

Trigger execution sequence:

1. When you open form:

(1) PRE-FORM

(2) PRE-BLOCK (block level)

(3) When-New-form-instance

(4) When-New-block-instance

(5) When-New-record-instance

(6) When-New-item-instance

2. When the cursor moves to the next record after a record is filled in:

(1) When-validate-record
(Only the entered records and existing records in the database are used for uniqueness verification. If only the data on the page is repeated and the database does not have a duplicate value, no error is reported .)

(2) When-New-record-instance

(3) When-New-item-instance

3. When you click "save ",

(1) When-validate-record
(Submit all the data on the page to the database. If there is duplicate data on the page, it is successfully submitted for the first time, but only writes the data to a temporary table in the database first, an error is reported when the second duplicate record is submitted. If the transaction is rolled back, the command that was successfully executed will also be revoked)

(2) PRE-INSERT

(3) On-insert

(4) Post-insert

(5) Post-forms-commit

(6) PRE-BLOCK (block level)

(7) Key-commit

(8) When-New-item-instance

4. When the cursor moves to the row already displayed in the current data block:

(1) When-Remove-record

(2) When-New-record-instance

(3) When-New-item-instance

When different items on the row are moved:

(4) When-New-item-instance

5. When modification is required (when an item in the record is modified ):

(1) On-Lock

6. When you save the changes:

(1) When-validate-record

(2) PRE-UPDATE

(3) On-Update

(4) Post-forms-commit

(5) PRE-BLOCK (block level)

(6) Key-commit

(7) When-New-item-instance

7. When deleting a record:

(1) On-Lock

(2) When-Remove-record

(3) KEY-DELREC

(4) When-New-record-instance

(5) When-New-item-instance

8. F11 Query Process:

(1) When-clear-block

(2) When-New-record-instance

(3) When-New-item-instance

After entering the query conditions, click Ctrl + F11:

(4) PRE-QUERY

(5) When-clear-block

(6) Post-Query

(7) When-New-record-instance

(8) When-New-item-instance

9. crrl + F11:

(1) When-clear-block

(2) PRE-QUERY

(3) When-clear-block

(4) Post-query (triggered once every record is queried)

(5) When-New-record-instance

(6) When-New-item-instance

10. When switching from query status (F11) to input status (F4:

(1) When-clear-block

(2) Key-exit

(3) When-New-record-instance

(4) When-New-item-instance

11. Flashlight Query Process:

(1) query_find (Block-level)

After entering the query conditions, click "query:

(2) When-clear-block

(3) PRE-QUERY

(4) When-clear-block

(5) Post-Query

(6) When-New-record-instance

(7) When-New-item-instance

12. When you click "new:

(1) When-New-record-instance

(2) When-New-item-instance

13. When you click "editfield:

(1) Key-Edit

14. When you click "windowhelp:

(1) Key-help

15. Click "clearrecord:

(1) When-Remove-record

(2) Post-Query

(3) When-New-record-instance

(4) When-New-item-instance

16. When you click F4 to close:

(1) Key-exit

(2) Post-Form

17. When you click "closeform" to close it:

(1) Key-exit

(2) Post-Form

18. When you click the "translations" button:

(1) Translations

19. When you click "close:

(1) When-window-closed

(2) Close-Window

(3) Key-exit

(4) Post-Form

20. Select the lov list:

(1) KEY-LISTVAL

(2) When-New-item-instance

21. When selecting the small entry before the record:

(1) When-New-record-instance

(2) When-New-item-instance (data item level)

(3) When-New-item-instance

22. When the cursor moves up or down:

(1) When-New-record-instance

(2) When-New-item-instance

Tag: execution sequence of Oracle form builder triggers