user defined exception.

From: Hugues Landry <landryh_at_discreet.com>
Date: 22 Jan 2002 11:24:23 -0800
Message-ID: <e7f97714.0201221124.4950c7ff@posting.google.com>

Hi Everyone,

Does anyone know how i can register an exception into the system so that when it throws it display a message specified by me !!

Here's some code

CREATE OR REPLACE PROCEDURE throwMyException IS

myException EXCEPTION;
BEGIN
RAISE myException;
END; When called this method produce this output :

ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "TESTDB.THROWMYEXECPTION", line 5

I know i can use the pragma exception_init to associate my exception to an already existing one, but is there a way to define this myself ??

Hugues Landry Received on Tue Jan 22 2002 - 13:24:23 CST