The SA_COMPONENTS.DROP_LEVEL procedure drops a level.
A level that is used in an existing label cannot be dropped.
Syntax
SA_COMPONENTS.DROP_LEVEL (
policy_name IN VARCHAR,
level_num IN NUMBER
);
Parameters
| Parameter | Description |
|---|---|
| policy_name | The policy name. You can query the POLICY_NAME column of the ALL_SA_POLICIES data dictionary view for existing policies. |
| level_num | The number of an existing level of the policy. You can query the LEVEL_NUM column of the ALL_SA_LEVEL view for existing level numbers. |
Examples
Drop the level whose number is 500 for the shield_agent_policy policy.
BEGIN
SA_COMPONENTS.DROP_LEVEL (
policy_name => 'shield_agent_policy',
level_num => 500);
END;
/