Re: Odp: Triggers on a table

From: <rtproffitt_at_my-deja.com>
Date: 2000/05/17
Message-ID: <8fuleh$jtf$1@nnrp1.deja.com>#1/1

Hello all,

My associate at my previous job was able to "fool" the trigger so it would not give a mutation error by doing the following: a commit and the insert could be executed through the dynamic package: DBMS_SQL

(this is perhaps "non-standard" methodology, and maybe someone could comment on this...)

2. Perhaps Thomas Kyte's info on mutating tables would help, see http://osi.oracle.com/~tkyte/Mutate/index.html

3. Put the process into a procedure, and call the procedure from the app... don't do a trigger. Then the procedure can easily do two inserts, call seq gen twice, then commit at the end...

HTH
Robert Proffitt
Beckman Coulter
Brea, California

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed May 17 2000 - 00:00:00 CDT