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

Post-Logon Trigger

Description

Fires after either of the following events:

Definition Level form

Legal Commands

SELECT statements, unrestricted Built-ins

Enter Query Mode no

Usage Notes

Use a Post-Logon trigger to provide an event point for a task such as setting up a custom environment with special variables--to initialize on an application level rather than a form-by-form basis. You might accomplish this by initializing special global variables from this trigger.

On Failure

Varies based on the following conditions:

  • If the trigger fails during the first logon process, Oracle Forms exits the form, and returns to the operating system.
  • If the trigger fails after a successful logon, Oracle Forms raises the Built-in exception FORM_TRIGGER_FAILURE .
  • Fires In

    LOGON

    Post-Logon Trigger Example

    This example calls a user exit to log the current username and time to an encrypted audit trail file on the file system, which for security reasons is outside the database.

    BEGIN
    User_Exit('LogCrypt '||
    USER||' ' ||
    TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'));
    END;


    Logon (Form Compiler)