CWM_CLASSIFY , 10 of 19

DROP_CATALOG Procedure

This procedure deletes a measure folder. By default, you must delete subfolders before deleting a measure folder. However, if you set the cascade parameter, all subfolders are deleted along with the measure folder.

Syntax

DROP_CATALOG (
   catalog_id        IN   NUMBER,
   cascade           IN   VARCHAR2);

Parameters

Table 28-13 DROP_CATALOG Procedure Parameters

Parameter	Description
`catalog_id`	Identifier of the measure folder.
`cascade`	Whether or not the subfolders should be deleted with the measure folder. Values may be `Y` or `N`. `Y` means that subfolders will be deleted. `N` means that subfolders will not be deleted, and if there are subfolders the measure folder will not be deleted. The default is `N`.

Exceptions

Table 28-14 DROP_CATALOG Procedure Exceptions

Exception	Description
`catalog_has_sub_catalogs`	You must drop the subfolders before deleting the measure folder.
`catalog_not_found`	Measure folder not found.