Re: Exceptions

Sandy 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

You don't really give sufficient details of how your application works and what you are trying to do when the error occurs, but here is a suggestion at least.

Perform the operation that is causing the problem in a seperate function. The function would do something like this:

function doit(-whatever parmaters are needed-) return integer is begin

    /* do work here */
    return(0)
exception

    when others then

        return(sqlcode);
end;

When you call this funtion you would check the return value. If you get a return value of 0 it means the operation was successful. If you get a non-zero then you will have to trap out whatever oracle error numbers you want to allow so that you can continue processing and treat all other errors as fatal errors and the program should exit with an error indication. Received on Wed Mar 29 2000 - 15:16:21 CEST