Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Pipelined functions error (ORA-06548) appears in Oracle Database 11.2.0.4.0. Is there some configura

edited Apr 23, 2016 5:02AM in Database Install/Upgrade/Opatch (MOSC) 1 commentAnswered

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 (

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center