Article View: borland.public.interbase.sql
Article #1028Re: Error Handling in Stored Procedures
From: Patrick Moloney
Date: Sat, 17 Mar 2007 13:44
Date: Sat, 17 Mar 2007 13:44
19 lines
1750 bytes
1750 bytes
Bill Todd wrote: > See the WHEN...DO statment in the Language Reference then post again > if you still have questions. I read the When...Do and more (100x) which led me to my 2 questions. 1. Apparently I have to list every exception I'd like to trap. I'd rather not have to make that list (and maintain it). By default IB stops and displays any exception to the user. I just want to record any exception and continue with the next record. 2. I see no documentation on how to capture the exception message. The only thing I can devise is to list every exception in my When statement, (meaning I provide the exception name), then retrieve the message from the system tables using that name. If, as I suspect, this is the best there is, then we have an area for IB enhancement here. -- Patrick Moloney
Technical Details
Message-ID:
<45fbe299$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<45fb1f50$1@newsgroups.borland.com> <45fb39ab$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,16fac437688a8716 X-Google-Attributes: gid114a0e,public X-Google-Language: ENGLISH,ASCII-7-bit From: "Patrick Moloney" <NewsID*at*SandrockSoftware.c*o*m> Subject: Re: Error Handling in Stored Procedures Newsgroups: borland.public.interbase.sql Reply-To: "Patrick Moloney" <NewsID@SandrockSoftware.com> References: <45fb1f50$1@newsgroups.borland.com> <45fb39ab$1@newsgroups.borland.com> User-Agent: XanaNews/1.18.1.3 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 NNTP-Posting-Host: 151.204.132.253 Message-ID: <45fbe299$1@newsgroups.borland.com> Date: 17 Mar 2007 05:44:09 -0800 X-Trace: newsgroups.borland.com 1174135449 151.204.132.253 (17 Mar 2007 05:44:09 -0800) Lines: 19 Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail