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.
Built-in Type unrestricted function
Returns ParamList
Enter Query Mode yes
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.
/*
** 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;