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

DESTROY_PARAMETER_LIST Built-in

Description

Deletes a dynamically created parameter list and all parameters it contains.

Syntax

PROCEDURE DESTROY_PARAMETER_LIST
(list VARCHAR2);

PROCEDURE DESTROY_PARAMETER_LIST
(name VARCHAR2);

Built-in Type unrestricted procedure

Enter Query Mode yes

Parameters

list or name 
 
Specifies the parameter list, either by list ID or name. The actual parameter can be either a parameter list ID of type PARAMLIST, or the VARCHAR2 name of the parameter list.

Usage Notes

When a parameter list is destroyed using DESTROY_PARAMETER_LIST the parameter list handle is NOT set to NULL.

Use the GET_PARAMETER_LIST Built-in to return the ID to a variable of the type PARAMLIST.

DESTROY_PARAMETER_LIST Examples

/*

** Built-in: DESTROY_PARAMETER_LIST
** Example: Remove the parameter list 'tempdata' after first
** checking to see if it exists
*/
DECLARE
pl_id ParamList;
BEGIN
pl_id := Get_Parameter_List('tempdata');
IF NOT Id_Null(pl_id) THEN
Destroy_Parameter_List(pl_id);
END IF;
END;


CREATE_PARAMETER_LIST Built-in