Comment by Duke Ganote on Mini-Tip #9: No Data Found: Bug or Feature?

I suppose I better try to commit this (mis)behavior to memory, since it just bit me again today. The 10gR2 documentation includes this about NO_DATA_FOUND “Because this exception is used internally by some SQL functions to signal completion, you should not rely on this exception being propagated if you raise it within a function that is called as part of a query.”

http://tinyurl.com/5o7ze3

My exception clause now looks like:

EXCEPTION

WHEN NO_DATA_FOUND THEN

RAISE