Re: Ignore ORA 942 Error

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Tue, 12 Oct 2004 13:06:22 +0200
Message-ID: <rkenm0hcme1sldrboec2g66dihve65k3is@4ax.com>

On 12 Oct 2004 03:07:52 -0700, nmdavies1104_at_hotmail.com (Neil) wrote:

>I have a unix script that includes a DROP TABLE and CREATE TABLE
>command in SQL Plus.it works fine if the table to drop is there. If
>not the script ends. Can anyone advise how I can ignore the
>"ORA-00942: table or view does not exist" error and continue to the
>next command?

add
whenever sqlerror continue
as first statement to the sql part

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Oct 12 2004 - 06:06:22 CDT