Toad World® Forums

toad 10.5 debugger no_data_found exception


#1

In a procedure I have a Exception that traps a no_data_found and sets some switches accordingly. Trouble is when stepping through the code with the debugger it keeps sending a pop up window indicating the exception.

The procedure is looping through a cursor with more than a 1000 rows and most of them cause the exception. When I try to trace out of the procedure it keeps going back to the exception handler.

Is there any trick to keep the debugger from stopping at the no_data_found exception?

Thanks
Jim


#2

Uncheck Options -> Debugger -> Break on Exceptions