Re: Hide Oracle error messages

From: Venkat <vreddy_at_no_spamix.netcom.com>
Date: Tue, 2 Jun 1998 10:07:26 -0400
Message-ID: <6l10uk$19l@dfw-ixnews8.ix.netcom.com>

Karina,
In your DECLARE portion use PRAGMA EXCEPTION_INIT. This is a compiler directive which tells Oracle what name to associate an error number with.

DECLARE
--your variables etc
PRAGMA EXCEPTION_INIT(index_not_found, 01418); BEGIN
--your code
EXCEPTION
WHEN index_not_found THEN
--do whatever
END; A better solution for your situation would be to write a procedure that accepts a DROP INDEX statement and then call that proc whereever you need to drop an index.

HTH
Venkat

>
>Actually, the solution you suggested is the one I'm trying to put in place.
>But, since I'm far from being a PL/SQL guru, this solution didn't work the
way
>I thought.
>
>Following is the script I'm running. Would you spare me a couple of minutes
to
>find out what's wrong in my approach?
Received on Tue Jun 02 1998 - 09:07:26 CDT