My Oracle Support Banner

Call to Pipeline Function May Not see Session Updates if Using a With Clause and Query is Complex (Doc ID 1546116.1)

Last updated on APRIL 16, 2013

Applies to:

PL/SQL - Version 10.2.0.5 and later
Information in this document applies to any platform.

Symptoms

Calling a pipleline function that uses a with clause and a complex sub-query may not see the session updates if the optimizer decides to materialize the data in a global temporary table.

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
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.