=?utf-8?B?UkU6IEluZm9ybWl4IFVzZXIgRGVmaW5lZCBFeGNlcHRpb24=?=

You can use the RAISE EXCEPTION and ON EXCEPTION statements available in SPL (now called UDR). This will catch the errors and its up to you what to do with it. However, you should have an idea on what possible errors your UDR might encounter, such as locks, data type errors, etc. Or you can issue your own general message. Don -----Original Message----- From: fsu [mailto:fsu@bbn.com] Sent: Thursday, August 17, 2000 12:10 PM To: informix-list@iiug.org Subject: Informix User Defined Exception Hi, We are using Informix 9.2. And, there are situations that, when a stored procedure encounters a database issue, I would like to send a meaningful message to the user. But, we were told by Informix tech suport that, we have to chagne a txt file, and re-compile it. However, they were not willing to provide us with the compiler. Question - is there any way I can check on stored procedure, and response to the user with a"User Defined Message", vs. systems message ? Any thoughts, or comments will be appreciated ! Fan - Ming (fsu@genuity.com)