Pipelined functions error (ORA-06548) appears in Oracle Database 11.2.0.4.0. Is there some configura
In the database there some pipeline functions working fine on Oracle Database 11.2.0.3.0.
But after upgrade to 11.2.0.4.0, now is getting the error ORA-06548: no more rows needed.
Is there a way to change some Oracle Database configuration to pipeline function work like 11.2.0.3.0? If not is it something that Oracle is thinking to fix as the workaround is not really pretty.
The database is set with the parameters:
compatible=11.2.0.0.0
optimizer_features_enable=11.2.0.4
The problem occurs with this kind of select:
select * from (
select * from table(pipelined_function(null))
) where rownum < 10;
I could find some docs about the problem:
Bug 13088409 - RAISE_APPLICATION_ERROR ignored in a WHEN OTHERS / WHEN NO_DATA_FOUND exception handler of a pipe-lined table function (