Re: Triggers & Mutating Tables
From: Bob Larson <rcl_at_cray.com>
Date: Sun, 16 Oct 1994 05:09:45 GMT
Message-ID: <Cxr2CA.C2p_at_cray.com>
Date: Sun, 16 Oct 1994 05:09:45 GMT
Message-ID: <Cxr2CA.C2p_at_cray.com>
There is a good article Titled "ORACLE 7 triggers: The Challenge of Mutating Table:" (2-parts) describing mutating tables in this months (and last: Sep & Oct) Database Programming Design Magazine. The short answer is that you often need to have the row-level trigger write to a scratch table and then apply those changes on an "after SQL statement" trigger.
-- Robert C Larson rcl_at_oregon.cray.com <| Don't try to reply if it says rcl_at_walter.cray.comReceived on Sun Oct 16 1994 - 06:09:45 CET