Re: SQL*PLUS: how to supress error msg
From: Günter Thaler <guenter_thaler_at_sws.at>
Date: Wed, 27 Jan 1999 13:23:34 +0100
Message-ID: <78n06k$d7b$1_at_minerva.ins.at>
Date: Wed, 27 Jan 1999 13:23:34 +0100
Message-ID: <78n06k$d7b$1_at_minerva.ins.at>
karsten schrieb in Nachricht <36AE2D92.725F5D14_at_PAMt-gis.shl.com>...
>I am trying to suppress error messages
>...
[Quoted] you can handle each oracle-error with pragma exception_init ...
example:
declare
no_synonym exception;
pragma exception_init(no_synonym , -1434) ;
begin
drop synonym ....
exception
when no_synonym then
null;
end;
nice working
gue
-- +---------------------------------+-------------------------+ | Guenter THALER | /\ / | | SWS EDV Software Service GmbH | /\ / \ / 4 | | Stachegasse 13, 1120 Vienna | / \ /_ _\ / 4 | +---------------------------------+ /_ _\ || / 4 | | phone:(+43-1) 80 135-54 | || /\ / 4 4 | | fax:(+43-1) 80 135-10 | / \ / 44444444 | | mailto:tg_at_sws.at | /_ _\ / 4 | | http://www.sws.at/ | || / 4 | +---------------------------------+-------------------------+Received on Wed Jan 27 1999 - 13:23:34 CET