Database Error Messages

OCI-28094

SQL construct not supported by data redaction.

Cause

The query had a SQL construct that was not supported by data redaction.


Action

The ORA-28094 is a legacy error which can occur in the Oracle Database release 19c, whereas starting from the Oracle Database release 23ai, data redaction performs full redaction (DBMS_REDACT.FULL) rather than raising the ORA-28094 error, to avoid placing any limitation on the kind of SQL construct that a query involving redacted columns can use. Check the Oracle Documentation for the correct syntax, rewrite the query to avoid using an unsupported construct, and retry.