'Privileges to call a pipelined function inside a package
I have a pipelined function created outside a package which I can call like this and successfully returns the desired output:
SELECT
*
FROM
( TABLE ( my_function() ) );
However, if I try to create inside a package and try to call it, the below error message is raised.
SELECT
*
FROM
( TABLE ( my_package.my_function() ) );
ORA-64610: bad depth indicator
ORA-06512: at "SYS.UTL_CALL_STACK", line 19
ORA-06512: at "MY_SCHEMA.MY_PACKAGE", line 3
64610. 00000 - "bad depth indicator"
*Document: NO
*Cause: There was no subprogram, error, or backtrace at the specified stack
depth.
*Action: Specify a depth for which there is a subprogram, error,
or backtrace.
What privileges do I need to make this work?
DB version would be: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
