Article View: borland.public.interbase.sql
Article #825Re: Abort a Trigger
From: Bill Todd
Date: Sun, 13 May 2007 12:44
Date: Sun, 13 May 2007 12:44
16 lines
1434 bytes
1434 bytes
Adalberto Baldini wrote: > if I don't manage error in executed procedure, > a) trigger gets an automatic exception and also raises an exception ? > b) or I need to raise my exception in trigger to force a rollback? Assuming the following: A trigger call a stored procedure. Neither the trigger or the stored procedure contain a WHEN block that handles the exception. If an exception is raised in the stored procedure both the stored procedure and the trigger will roll back. -- Bill Todd (TeamB)
Technical Details
Message-ID:
<46470811$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<4646324d@newsgroups.borland.com> <46465356$1@newsgroups.borland.com> <4646bf7a$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,a5001e52ced62223
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd" <no@no.com>
Subject: Re: Abort a Trigger
Newsgroups: borland.public.interbase.sql
References: <4646324d@newsgroups.borland.com> <46465356$1@newsgroups.borland.com> <4646bf7a$1@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.6
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
NNTP-Posting-Host: 76.208.17.70
Message-ID: <46470811$1@newsgroups.borland.com>
Date: 13 May 2007 05:44:01 -0700
X-Trace: newsgroups.borland.com 1179060241 76.208.17.70 (13 May 2007 05:44:01 -0700)
Lines: 16
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail