Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: WHENEVER SQLERROR does'nt always work

Re: WHENEVER SQLERROR does'nt always work

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 26 Jun 2003 22:31:25 +0200
Message-ID: <cvlmfv4unbuhn3qe6351820n9fl0bbhkt5@4ax.com>


On 26 Jun 2003 05:09:48 -0700, ni4ni_at_hotmail.com (Guy) wrote:

>Hi
>
>I have a set of sql scripts that creates several tables and them
>populates them with rows (via insert statements).
>Each script begins with WHENEVER SQLERROR... and WHENEVER OSERROR...
>So it should halt once an error occures. I thought this will cover all
>possible errors.
>The problem is that it doesnt work with all kinds of errors. For
>example, if I wrote "nsert into" instead of "insert into" then
>SQL*PLUS throws this error message: SP2-0734: unknown command
>beginning "NSERT INTO..." but execution doesnt stop.
>
>Does it mean that WHENEVER SQLERROR doesnt catch "SP2" errors ? is
>there a way to catch this kind of errors ? I could'nt find a clue in
>SQL*PLUS documentation.
>
>
>T.I.A
>
>Guy

Why catch parsing errors? Your scripts are static aren't they? Just correct the incorrect statement obviously

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jun 26 2003 - 15:31:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US