PipeLined Function PL/SQL ERR Stack Shows Wrong Line For PLSQL_OPTIMIZE_LEVEL>1
Last updated on MARCH 30, 2018
Applies to:PL/SQL - Version 220.127.116.11 and later
Information in this document applies to any platform.
If a pipelined function is called by a PL/SQL procedure or function that is compiled with PLSQL_OPTIMIZE_LEVEL set to 2 (the default) or 3 then in case it raises an exception at runtime, the resulting error stack does not include the line number from the pipelined function.
The following PL/SQL code demonstrates the issue:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms