Exception thrown for ORA-0000
I have a pl/sql function that is throwing an exception with a SQLCODE = 0 and Message of "Oracle error 00000". The line that is throwing the exception is a for loop with a query and this query does successfully retrieve data earlier in the call stack. If I run the specific query in sql developer using the correct bind variable values and the query does return results.
I understand pl/sql has a stack depth of 50 for recursive functions and this problem shows up much earlier than the 50th call. Please note that this function is a pipelined function.
Here is a psuedo code of the function: