Re: Returning from Exception Handler

In article <00001a1b+00007d0d_at_msn.com>, richu_at_msn.com (Richard Hu) wrote:

> What you need to do is put the looped DML statement in its own
> sub-block..therefore, when it causes an exception, you can
> handle it within that sub-block and still yet be able to
> continue on with the loop after the exception passes out of the
> sub-block..
>

Have read several discussions on the net stating that exceptions are meant for last resort right before termination error handling. Given that Exceptions don't seem like the most appropiate thing to continue from inside the same routine. I may be wrong though. My problem with Oracle 7.0 is that Exceptions don't seem to be awailable ..... When was Exceptions in Pl/SQL actually implemented? ORACLE 7.1 ? I use PL/SQL 2.0xx. Received on Mon Aug 12 1996 - 00:00:00 CEST