Re: WHENEVER SQLERROR doesn't work?

>
> Your syntax is new to me. What I'm used to seeing is:
>
> CREATE OR REPLACE PROCEDURE xyz IS
>
> BEGIN
>
> EXCEPTION
> WHEN the_exception THEN
> do_something;
>
> END;
>
> And I can guarantee you that when written this way it will always exit the
> procedure.
>

Misunderstanding. I want to exit when the error occures on the compilation time (not runtime) - when I load file myscript.sql into Oracle using SQLPLUS.

        Tomasz Received on Fri Mar 23 2001 - 06:29:05 CST