Database Error Messages

Release
toggle
  • 23ai
Updated
Jun 24, 2024

ORA-28096

The parameter parameter_name is unexpected for ADD_POLICY.
  • parameter_name: The parameter name that is unexpected.

Cause

The parameter in the call to the PL/SQL procedure was not NULL or was not equal to the default value.

If DBMS_REDACT.ADD_POLICY was called, the parameters OBJECT_NAME and POLICY_NAME are required.

If no COLUMN_NAME parameter was provided to DBMS_REDACT.ADD_POLICY, then it only accepts the EXPRESSION, OBJECT_SCHEMA, ENABLE, and POLICY_DESCRIPTION parameters. The EXPRESSION parameter is required. The OBJECT_SCHEMA, ENABLE, and POLICY_DESCRIPTION parameters are optional.

If a COLUMN_NAME parameter was provided to DBMS_REDACT.ADD_POLICY and the FUNCTION_TYPE parameter was DBMS_REDACT.PARTIAL, then the parameter FUNCTION_PARAMETERS is required and the parameters FUNCTION_TYPE, POLICY_DESCRIPTION, and COLUMN_DESCRIPTION are optional.

If a COLUMN_NAME parameter was provided to DBMS_REDACT.ADD_POLICY and the FUNCTION_TYPE parameter was DBMS_REDACT.REGEXP or DBMS_REDACT.REGEXP_WIDTH, then the parameters REGEXP_PATTERN and REGEXP_REPLACE_STRING are required and REGEXP_POSITION, REGEXP_OCCURRENCE, REGEXP_MATCH_PARAMETER, FUNCTION_TYPE, POLICY_DESCRIPTION, and COLUMN_DESCRIPTION are optional.


Action

Do not use combinations of parameters that are not supported.