Deletes a dynamically created parameter list and all parameters it contains.
PROCEDURE DESTROY_PARAMETER_LIST
(list VARCHAR2);
PROCEDURE DESTROY_PARAMETER_LIST
(name VARCHAR2);
Built-in Type unrestricted procedure
Enter Query Mode yes
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.
/*
** 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;