Re: What happens after an error in an PL/SQL proc?

In your example, oracle will break out of the loop and transfer control to the exception handler nearest in scope, which is the one you have at the end of the procedure. As David has indicated, if one doesn't exist, the procedure will exit.

If you wish to continue processing inside the loop after an exception is encountered, you would need to add a block and exception handler inside of the loop.

Hope that helps,
Gavin

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 15 2000 - 16:49:47 CST