Re: Exceptions

Try this

loop
  <do something>
  begin
    <your-action-that-may-fail>
    <do-something-else-only-if-the-action-didn't-fail>   exception when others then
    null; <do-nothing>
  end;
  <do-something-even-if-the-action-did-fail> end loop;

-obv

On Wed, 29 Mar 2000 05:56:50 -0800, Sandy <daleelaNOdaSPAM_at_usa.net.invalid> wrote:

>Hi,
>
>In my loop there is an ora- error and then my procedure
>stops saying then that it is impossible to do any action
>because there is not enough privilege.
>I would like it to continue for the next rows those for
>whom i have privileges. I suppose I must do it with
>exceptions but i dunno how .
>
>Thanks
>
>Sandy
>
>
>
>* Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful
Received on Wed Mar 29 2000 - 16:28:11 CEST