oracle Form Builer:FIND_FORM Built-in

时间:2022-09-22 10:29:11

Description

Searches the list of forms and returns a form module ID when it finds a valid form with the given name.

you must define an appropriately typed variable to accept the return value. Define the variable with a type of Formmodule.

Syntax

FUNCTION FIND_FORM

(formmodule_name VARCHAR2);

Built-in Type unrestricted function

Returns Formmodule

Enter Query Mode yes

Parameters

formomodule_name

  Specifies a valid VARCHAR2 form name.

FIND_FORM Examples

/*** Built-in: FIND_FORM ** Example: Find a form's Id before inquiring about several ** of its properties */
DECLARE
  fm_id  FormModule;
  tmpstr VARCHAR2(80);
BEGIN
  fm_id  := Find_Form(:System.Current_Form);
  tmpstr := Get_Form_Property(fm_id, CURSOR_MODE);
  tmpstr := tmpstr || ',' || Get_Form_Property(fm_id, SAVEPOINT_MODE);
  Message('Form is configured as: ' || tmpstr);
END;