My Oracle Support Banner

Getting Error On VPD After Upgrading From 12.1 To 12.2 (Doc ID 2428633.1)

Last updated on AUGUST 10, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Creating a table with a virtual column like:

create table TEST.TABLE(id_nat_pers NUMBER(11) not null,
bsn_nr NUMBER(9),
bsn_nr_pseudo as (SUBSTR("DM"."F_HASH_BSN"("BSN_NR"),1,32)))

and a policy that for some users they cannot see the bsn_nr column. This column is used for joining tables (with the same construction)
To still make it usable we have introduced the virtual column to join different tables on the bsn_nr_pseudo column. Everybody can see the bsn_nr_pseudo column.

This worked fine in 12.1 but now in 12.2 the following error is present:

SELECT COL 1, COL 2, COL 3 FROM TEST.TABLE;
FROM TEST.TABLE
*
FOUT in regel 2:
.ORA-28113: Fout in policypredicaat.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.