This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The following Oracle error occurs when testing a simple query (select * from tablename) in the SQL Editor tab of the Visual Query Builder pop-up window.
ORA-28094: SQL Construct Not Supported By Data Redaction
Oracle Instant Client
An ORA-28094: SQL construct not supported by data redaction error is raised if a query involves a UNION of redacted columns and each branch of the UNION does not have the same redaction policy. In this case, the table was actually a view, which contained redacted columns, so is not immediately obvious to the user. Although Oracle Database does not support complex SQL that involves redacted columns, this error is not raised if the user who is executing a query with complex SQL has the EXEMPT REDACTION POLICY system privilege.
Rewrite the query to avoid using an unsupported construct. Consult the Oracle documentation for details.
Where it's not possible to rewrite the query (e.g. querying a view that contains the mismatched redacted columns) contact your DBA to request the EXEMPT REDACTION POLICY privilege.