Database Error Messages

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

ORA-42077

The XML column type is unsupported as a VPD sensitive column.

Cause

An attempt was made to create an Oracle Virtual Private Database (VPD) policy (DBMS_RLS.ADD_POLICY or DBMS_RLS.ADD_GROUPED_POLICY) that specified an XML column for the SEC_RELEVANT_COLS parameter. XML column types are not supported for the SEC_RELEVANT_COLS parameter.


Action

Review your data access security requirements. You can:

  • Remove the XML column from the SEC_RELEVANT_COLS parameter.
  • Map the data from the XML column to a supported column type and use the new column as a value for the SEC_RELEVANT_COLS parameter.