Database Error Messages

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

ORA-40574

JSON operation on redacted column col_name not allowed.
  • col_name: The redacted column name on which the operation was attempted.

Cause

An attempt was made to use a JavaScript Object Notation (JSON) operation on a column that had an Oracle Data Redaction policy.


Action

Drop the Oracle Data Redaction policy. Re-create the Oracle Data Redaction policy on a new view over the column, if needed.