My Oracle Support Banner

PipeLined Function PL/SQL ERR Stack Shows Wrong Line For PLSQL_OPTIMIZE_LEVEL>1 (Doc ID 2380660.1)

Last updated on FEBRUARY 18, 2019

Applies to:

PL/SQL - Version 9.2.0.8 and later
Information in this document applies to any platform.

Symptoms

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:

 

Cause

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
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.