A script-enabled browser is required for this page to function properly.

On-Sequence-Number Trigger

Description

Fires when Oracle Forms would normally perform the default processing for generating sequence numbers for default item values. Replaces the default series of events that occurs when Oracle Forms interacts with the database to get the next value from a SEQUENCE object defined in the database.

Definition Level form, block, or item

Legal Commands

SELECT statements, unrestricted Built-ins

Enter Query Mode no

Usage Notes

When a SEQUENCE is used as a default item value, Oracle Forms queries the database to get the next value from the SEQUENCE whenever the Create Record event occurs. Suppress or override this functionality with an On-Sequence-Number trigger.

To perform the default Oracle Forms processing from this trigger, call the GENERATE_SEQUENCE_NUMBER Built-in.

On Failure

no effect

Fires In

GENERATE_SEQUENCE_NUMBER