Re: Mutating Tables

The mutating tables pblm occurs only in 'for each row' triggers. A workaround consists of either of the following solutions:
1- if the statements are usually one record at a time, use a package in which you initialize

   some variables to the columns of the record that you want to treat, and create a statement    trigger that will use these variables to process the record. 2- if the statement includes several rows at a time, insert the rows in a temporary table,

   and create a statement trigger that opens a cursor on this table and processes each record    alone.

hope this helps
josef_at_mars.softouch.bc.ca (Jozef Starosta) wrote:
>Reinhard Bergander (100330.2165_at_CompuServe.COM) wrote:
>: Has anybody a workaround for the mutating tables bug ?
 

>: Even deleting all constraints (only using unique keys and
>: db-triggers ) doesn't solve this problem !
 

>: Thanx in advance,
 

>: reinhard
 

>: --
>: -------------------------------------------------
>: Reinhard Bergander 100330.2165_at_compuserve.com
>: KLINIK-OP DATA Software GmbH
>: -------------------------------------------------
>
Received on Fri Jul 28 1995 - 00:00:00 CEST