Re: Q:How to use RAISE EXCEPTION in SPL?

Jim Gordon (jgordon@systems.DHL.COM) wrote: : > If you use error no, I think it's -769 or something close by, the error : > text is simply '%s', so it takes whatever message you supplied. The : > version 6.00 manuals tell you all about using this. The number is : > specifically set aside for custom SPL errors. : -745 is the number Now I'm getting a little confused! -769 is definitely wrong. Finderr says "message number not found". For -745, finderr says: -745 Trigger execution has failed. This message is defined for general use to apply to error conditions that you specify in a stored procedure that is a triggered action. But there is also -746: -746 message-string This is a message for which you supply message-string. You can apply this message to error conditions that you specify in a stored procedure that is a triggered action. The corrective action for this error depends on the condition that caused it. Both the condition and the message text are defined by you, the user. Now which one is correct for what purpose? IMHO, the answer to the original poster's question should be -746. Regards, Richard -- +----------------------------+-------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3421 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | | +----------------------------+-------------------------------------------+