Re: Ignore ORA 942 Error

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 12 Oct 2004 09:41:34 -0700
Message-ID: <92eeeff0.0410120841.42a397a0@posting.google.com>

Looks like there is a "whenever sqlerror exit" line (without quotes) in the script before these statements execute. Before commenting it out... check to see why it was there in the first place.

Regards
/Rauf

nmdavies1104_at_hotmail.com (Neil) wrote in message news:<caef6318.0410120207.4ae42d2a_at_posting.google.com>...
> 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?
Received on Tue Oct 12 2004 - 11:41:34 CDT