My Oracle Support Banner

Wrong Results With ANSI Joins and VPD policies / Inline Views (Doc ID 1073138.1)

Last updated on AUGUST 17, 2022

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 11.2]
Information in this document applies to any platform.


Wrong results are produced when using an ANSI outer join on a table protected by a RLS policy. The problem can be reproduced also with an inline view that simulates the behaviour of RLS.


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

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