My Oracle Support Banner

SQL Query With Pipelined Function in the Where Clause is Hanging (Doc ID 1435109.1)

Last updated on MARCH 04, 2022

Applies to:

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

Symptoms

When running SQL query which includes pipelined function on test database it's ok, but on production database it gets stucked and never ends.

The workaround for this behavior is to double the condition, which allow query to run properly and returns results immediately. This part of code solves the issue:

All databases are 10.2.0.5.

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


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