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

CREATE_PARAMETER_LIST Built-in

Description

Creates a parameter list with the given name. The parameter list has no parameters when it is created; they must be added using the ADD_PARAMETER Built-in. A parameter list can be passed as an argument to the CALL_FORM, NEW_FORM, OPEN_FORM, RUN_REPORT_OBJECT, and RUN_PRODUCT Built-in subprograms.

Syntax

FUNCTION CREATE_PARAMETER_LIST
(name VARCHAR2);

Built-in Type unrestricted function

Returns ParamList

Enter Query Mode yes

Parameters

name 
 
Specifies the VARCHAR2 name of the parameter list object.

When Oracle Forms creates the object, it assigns it a unique ID of type PARAMLIST. You can call the parameter list by name or by ID in later calls to parameter list-related Built-in subprograms.

CREATE_PARAMETER_LIST Restrictions

CREATE_PARAMETER_LIST Example

/*

** Built-in: CREATE_PARAMETER_LIST
** Example: Create a parameter list named 'TEMPDATA'. First
** make sure the list does not already exist, then
** attempt to create a new list. Signal an error
** if the list already exists or if creating the
** list fails.
*/
DECLARE
pl_id ParamList;
pl_name VARCHAR2(10) := 'tempdata';
BEGIN
pl_id := Get_Parameter_List(pl_name);
IF Id_Null(pl_id) THEN
pl_id := Create_Parameter_List(pl_name);
IF Id_Null(pl_id) THEN
Message('Error creating parameter list '||pl_name);
RAISE Form_Trigger_Failure;
END IF;
ELSE
Message('Parameter list '||pl_name||' already exists!');
RAISE Form_Trigger_Failure;
END IF;
END;