ORA-28095
- parameter_name: The parameter name that is unexpected.
- action: The action chosen for ALTER_POLICY.
Cause
The parameter in PL/SQL function was not NULL or was not equal to the default value.
If DBMS_REDACT.ALTER_POLICY was invoked, the parameters object_name and policy_name are required.
If the action is DBMS_REDACT.ADD_COLUMN or DBMS_REDACT.MODIFY_COLUMN, only the following parameters are accepted:
- Required:
- column_name
- Only when function_type is DBMS_REDACT.PARTIAL
- function_parameters
- Only when function_type is DBMS_REDACT.REGEXP or DBMS_REDACT.REGEXP_WIDTH
- regexp_pattern
- regexp_replace_string
- Optional:
- function_type
- policy_description
- column_description
- Only when function_type is DBMS_REDACT.REGEXP or DBMS_REDACT.REGEXP_WIDTH
- regexp_position
- regexp_occurrence
- regexp_match_parameter
If the action is DBMS_REDACT.DROP_COLUMN, it only accepts the required column_name parameter.
If the action is DBMS_REDACT.MODIFY_EXPRESSION, it only accepts the following parameters:
- Required:
- expression
- Optional:
- policy_description
If the action is DBMS_REDACT.SET_POLICY_DESCRIPTION, it only accepts the optional policy_description parameter.
If the action is DBMS_REDACT.SET_COLUMN_DESCRIPTION, it only accepts the following parameters:
- Required:
- column_name
- Optional:
- column_description
Other parameters are not supported.
Action
Do not use parameters that are not supported.