Re: Ignore ORA 942 Error

From: Louis Frolio <froliol_at_yahoo.com>
Date: 12 Oct 2004 07:46:37 -0700
Message-ID: <94c28610.0410120646.63a6683f@posting.google.com>

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?

Why not put in a little code to check for the existence of this object, if it exists you gracefully move on to the next part of your code, if it does not you create it?

L Received on Tue Oct 12 2004 - 09:46:37 CDT