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.”
My exception clause now looks like:
WHEN NO_DATA_FOUND THEN
You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.