Re: Reserved Error Nums for "Raise Exception" Statement?

Ken Miles (kenm@vcd.hp.com) wrote: : My 12/91, "Guide to SQL Reference" Manual, Page 8-67 on stored procedures : says "The RAISE EXCEPTION statement is used to simulate an error. : The generated error can be trapped by an ON EXCEPTION statement". : This is great except that nowhere can I find a statement that tells : me what error numbers Informix has reserved for my use. So what are : they? Anyone at Informix have a clue? : I have noted the 3/94 "Informix Error Messages Version 6.0" Manual : Page IX which lists ranges of error messages used by the various Informix : products. It doesn't really help me either. It needs two lines added : to it: : Error Message Range Error Message Category : : . : +n / +m Reserved for Customer Use : . : -x / -y Reserved for Customer Use We use the following stored procedure to generate an error message from within a triggered action : CREATE PROCEDURE Error_Message (Message VARCHAR (80)) RAISE EXCEPTION -746, 0, Message;END PROCEDURE; I'm not sure whether this error number is reserved for use with triggers only, or not, but you could give it a try. ----------------------------------------------------------- Ria Vandenberghe Ria.Vandenberghe@rug.ac.be UNIVERSITY OF GHENT (BELGIUM) - Computer Science Laboratory Technologiepark-Zwijnaarde 9, B-9052 ZWIJNAARDE, BELGIUM tel: +32/9/264.55.10 fax: +32/9/264.58.42