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 and later
Information in this document applies to any platform.


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


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.