Re: Howto do Whenever error in PL/SQL

Hello, Amos

Excuse me about my English. My natural language is French.

First, have an exception bloc? It's the natural place for your statements about the inserts?

jo
Amos wrote:
>
>
> Hi,
>
> I'm doing a lot of execute immediate a loop inside a procedure.
> My problem is that if one of the exec fails, the SP terminates.
> What I want to do is something like whenever error do ... insert the
> statement that failed into an exception table and continue to exec the
 next
> command.
>
> Is there a way to do it in PL/SQL ??
>
>
> Cheers,
> Amos
>
>
>

--
Posted via CNET Help.com
http://www.help.com/