Re: Mutating error.

From: <rtproffitt_at_my-deja.com>
Date: 2000/04/14
Message-ID: <8d7hug$mi7$1_at_nnrp1.deja.com>#1/1


You are trying to alter data in a child table from inside the trigger of the parent table. The child table is mutating with respect to the snapshot of the child table that the parent sees....

See Thomas Kyte's article on mutating tables... http://osi.oracle.com/~tkyte/

    Avoiding Mutating Tables (HOWTO)
Robert Proffitt

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Apr 14 2000 - 00:00:00 CEST

Original text of this message