Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

DIA-28092

The parameter parameter_name with value 'parameter_value' has an error.
  • parameter_name: The name of the parameter that had an error.
  • parameter_value: The value that had an error.

Cause

The value of the parameter had an error.

If DBMS_REDACT.CREATE_POLICY_EXPRESSION was invoked and the POLICY_EXPRESSION_NAME parameter had an error, the policy expression name either already existed, or was invalid.

If DBMS_REDACT.DROP_POLICY_EXPRESSION was invoked and the POLICY_EXPRESSION_NAME parameter had an error, the policy expression either did not exist, was still in use (was applied to a column), or was invalid.

If DBMS_REDACT.APPLY_POLICY_EXPR_TO_COL was invoked and the POLICY_EXPRESSION_NAME parameter had an error, a policy expression may already exist on this column. Only one policy expression may be associated with any given column.

The name of any Oracle Data Redaction policy expression associated with a given column can be found in the REDACTION_EXPRESSIONS catalog view.

If the DBMS_REDACT.ADD_POLICY was invoked and the OBJECT_SCHEMA parameter referenced the APEX, Sharding (GSMADMIN_INTERNAL), or Spatial installation schema, the operation was prevented. Data redaction policies are not supported on objects within the APEX, Sharding (GSMADMIN_INTERNAL), or Spatial installation schema.

If the DBMS_REDACT.ADD_POLICY was invoked and the OBJECT_NAME referenced a metadata-linked view, the operation was prevented. Data redaction policies are not supported on metadata-linked views.

If the DBMS_REDACT.ADD_POLICY was invoked and the OBJECT_NAME referenced an OLAP analytic workspace table, the operation was prevented. Data redaction policies are not supported on OLAP analytic workspaces.


Action

Provide a valid value for the parameter.

If DBMS_REDACT.CREATE_POLICY_EXPRESSION was invoked and the parameter was POLICY_EXPRESSION_NAME, provide a valid (new or existing) policy expression name. The names of all existing Oracle Data Redaction policy expressions can be found in the REDACTION_EXPRESSIONS catalog view.

For the POLICY_EXPRESSION_NAME parameter of the DBMS_REDACT.DROP_POLICY_EXPRESSION procedure, provide a valid existing policy expression name that is not currently in use (applied to any column). The names of the columns to which a given policy expression is currently applied can be found in the REDACTION_EXPRESSIONS catalog view.

For the POLICY_EXPRESSION_NAME parameter of the DBMS_REDACT.APPLY_POLICY_EXPR_TO_COL procedure, either provide NULL to remove the current policy expression association of the column, or provide a valid existing policy expression name. There is currently no API to alter an existing association. It must first be dropped followed by applying the new association. The names of all existing policy expressions can be found in the REDACTION_EXPRESSIONS catalog view.

If DBMS_REDACT.ADD_POLICY was invoked, provide an OBJECT_SCHEMA that is not the APEX or Spatial installation schema. Data redaction policies are not supported on objects within the APEX or Spatial installation schema.

If DBMS_REDACT.ADD_POLICY was invoked, provide an OBJECT_NAME that does not reference either a metadata-linked view or an OLAP analytic workspace table.