Oracle Forms

CALL_FORM:

      Runs an indicated form while keeping the parent form active. Form Builder runs the called form with the same Runform preferences as the parent form. When the called form is exited Form Builder processing resumes in the calling form at the point from which you initiated the call to CALL_FORM.

NEW_FORM:

      Exits the current form and enters the indicated form. The calling form is terminated as the parent form. If the calling form had been called by a higher form, Form Builder keeps the higher call active and treats it as a call to the new form. Form Builder releases memory (such as database cursors) that the terminated form was using.

OPEN_FORM:

      Opens the indicated form. Use OPEN_FORM to create multiple-form applications, that is, applications that open more than one form at the same time.

EXIT_FORM:

      Provides a means to exit a form, confirming commits and specifying rollback action

  • In most contexts, EXIT_FORM navigates “outside” the form. If there are changes in the current form that have not been posted or committed, Form Builder prompts the operator to commit before continuing EXIT_FORM processing.
  • If the operator is in Enter Query mode, EXIT_FORM navigates out of Enter Query mode, not out of the form.
  • During a CALL_INPUT, EXIT_FORM terminates the CALL_INPUT function.

CLOSE_FORM:

      Opens the indicated form. Use OPEN_FORM to create multiple-form applications, that is, applications that open more than one form at the same time.

CLOSE_FORM Restrictions:

  • You cannot close a form that is currently disabled as a result of having issued CALL_FORM to invoke a modal called form.
  • You cannot close a form that has called you. For example, if Form_A calls Form_B, then Form_B cannot close Form_A.

User-Named Trigger:

      A user-named trigger is a trigger defined in a form by the developer. User-Named triggers do not automatically fire in response to a Form Builder event, and must be called explicitly from other triggers or user-named subprograms. Each user-named trigger defined at the same definition level must have a unique name.

      To execute a user-named trigger, you must call the EXECUTE_TRIGGER built-in procedure, as shown here:

      Execute_Trigger('my_user_named_trigger');

                                                                                                                             Previous     Next