Database Error Messages

OCI-28095

The parameter parameter_name is unexpected for ACTION action for ALTER_POLICY.
  • 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.