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.
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.
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