PL/SQL (MOSC)

MOSC Banner

Exception thrown for ORA-0000

edited Mar 17, 2017 5:00AM in PL/SQL (MOSC) 2 commentsAnswered

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center