The exception we never knew we needed
If, by some great random cosmic chance, you are a reader of this blog, but not of Tom Kyte‘s, then you would have missed this post:
NO_DATA_NEEDED – something I learned recently
It appears to have been documented in the 9i documentation, complete with spelling error:
ORA-06548, 00000, "no more rows needed"
Cause: The caller of a pipelined function does not
need more rows to be produced by the pipelined
function.
Action: Catch the NO_DATA_NEEDED exception is an
exception handling block.
Mind you, it’s not all that obvious since if the pipelined function does not handle the exception, nothing goes wrong – the exception is never raised by the calling SQL statement. It’s not obvious when ORA-06548 would ever be raised.
EDIT:
Looks like ORA-06548 can appear in the error stack.
About Jeffrey Kemp
Application Designer & Developer at Oracle specialising in Oracle APEX (Application Express), Oracle SQL and PL/SQL. Oracle ACE Alumni ♠️. Piano player, father, husband, Christian. The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.