Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Arnaud ANDRIEUX — — source: Informix-list mailing list archive (1991-1998)
Hi again,
I need feedback on exception management within stored procedures. All of
my procedures have the following structure :
CREATE PROCEDURE myproc ( ... )
RETURNING ...;-- variable definition and initialization
BEGIN
-- exception management bloc
ON EXCEPTION SET v_errnum, v_eisam
IF v_errnum IN (...) THEN
-- do something special
ELSE
RAISE EXCEPTION v_errnum, v_eisam;
END IF;
END EXCEPTION;
-- do something
RETURN (...);
END
END PROCEDURE;
So all of the exceptions that are fired are passed out of myproc by the
'exception management bloc'. It works well but I loose the message part
of the exception. For example, if the exception -268 (unique constraint
violated) is fired, I get the folowing message in the process which
executed myproc :
"..... SQL error [-268] : unique constraint ( ) violated. [ISAM Error
...........]"
But the message I want to get back is the following :
"..... SQL error [-268] : unique constraint ('constraint_name')
violated. [ISAM Error ...........]"
So how is it possible to manage exceptions with keeping track of the
complete message ? Is there a variable to SET and RAISE with v_errnum
and v_eisam ? If yes, wich data type is it ?
Thanks for your help.
--
- ------------------------------------------------------------------ -
- Arnaud ANDRIEUX tel direct : 02.99.12.52.22 -
- Alliance Qualite Logiciel http://www.aql.fr -
- GROUPE SILICOMP http://www.silicomp.fr -
- Rue de la Chataigneraie - B.P. 127 -
- 35513 CESSON SEVIGNE - FRANCE -
- tel : (33) (0)2.99.12.50.00 fax : (33) (0)2.99.63.70.40 -
- ------------------------------------------------------------------ -
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.