HELP!!! How to disable error message ORA-XXXX in a script ???

Dear all,

I am writting a .sql script and I would like to prevent any unwanted error
message to be prompted to the end user. In this script there are the ususal
drop table...
create table...

If the table does not exist, the drop issues an ORA-0942 error! This is fine, except that an uninitiated on looker might not know that this is ok and must be regarded as a warning, not an error. No use to panic ;-)

I can always check before hand and drop only if...

But if I recall correctly there is a way to filter out unwanted messages.
Something like ignore(0942) or ignore ('ORA-0942')...

Does this ring any bells to anyone out there? I can't recall the statement
or where I saw it :( Can you provide reference or syntax???

Any hints will be appreciated.

Thanks.

ps. Please reply to my email.

Guy Thibault
guy.thibault_at_informission.ca Received on Mon Apr 27 1998 - 14:07:40 CDT