Open_Form in Oracle Forms Example

In Oracle Forms, Open_form built-in is used to open a form from another form.

Open_Form Examples

1. Open a form without parameter in Oracle Forms

In this example, it will call the form emp without passing any parameter to it.

open_form('emp', activate, no_session);


open_form in oracle forms
2. Open a form with the parameter in Oracle Forms

In this example, it will call the emp form with the parameter to display the current date on the form.

v_parm paramlist;


v_parm := Get_Parameter_List('empparam');

IF NOT Id_Null(v_parm) THEN

v_parm := CREATE_PARAMETER_LIST ('empparam');

ADD_PARAMETER (v_parm, 'P_DATE', text_parameter, to_char(sysdate, 'dd/mm/yyyy'));

OPEN_FORM ('emp', activate, no_session, v_parm);



open_form to call another form in Oracle Forms

See also:

  1. Create Tree Menu in Oracle Forms
  2. Free Oracle Forms Application Download
  3. Oracle Form Stacked Canvas Example
  4. PL/SQL Topics
  5. SQL Topics

Vinish Kapoor

An Oracle Apex Consultant, Oracle ACE, and founder of and a question and answer forum for developers.

This Post Has 2 Comments

  1. Paulo Gomes

    Obrigado por compartilhar conhecimento com a comunidade de desenvolvedores.

  2. Jair Quezada

    Justo lo que necesitaba, muchas gracias!

Comments are closed.