Re: SQL*PLUS: how to supress error msg

Hi,

Günter Thaler wrote:
> 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;
>

 unfortunately, it is not that simple.
 I would have to create a cursor and use dbms_sql to drop  the synonyms. pl/sql itself does not have a 'drop ....'

 I have about 50 synonyms, and it is really painful to  modify all scripts to do this kind of thing.

Cheers Karsten Received on Wed Jan 27 1999 - 17:44:28 CET