The SA_LABEL_ADMIN.DROP_LABEL procedure drops the specified policy label.
An "Invalid Label" error will be reported if the label is subsequently referenced in data rows, user labels, or program unit labels after it is dropped.
Use this procedure only when setting labels. If you accidentally delete a label that is in use, you can restore the label by disabling and then re-enabling the policy.
Syntax
SA_LABEL_ADMIN.DROP_LABEL (
policy_name IN VARCHAR,
label_tag IN BINARY_INTEGER);
Parameters
| Parameter | Description |
|---|---|
| policy_name | The name of an existing policy. You can query the POLICY_NAME column of the ALL_SA_POLICIES view for existing policies. |
| label_tag | The integer tag assigned to the to-be-dropped label. You can query the LABEL_TAG column of the ALL_SA_LABELS view for existing labels. |
Notice
Do not drop labels that are being used by the database.
Examples
Drop the shield_agent_policy policy label based on its label_tag.
BEGIN
SA_LABEL_ADMIN.DROP_LABEL (
policy_name => 'shield_agent_policy',
label_tag => 50000);
END;
/