Re: Mutating table work-around?

From: M. Armaghan Saqib <armaghan_at_yahoo.com>
Date: Sat, 18 Mar 2000 02:31:18 GMT
Message-ID: <8auppn$h09$1@nnrp1.deja.com>

SQLPlusPlus (freeware) (BLDAPI command) generates all the PLSQL code required to avoid mutating trigger error.

regards,
M. Armaghan Saqib

+---------------------------------------------------------------
| 1. SQL PlusPlus => Add power to SQL Plus command line
| 2. SQL Link for XL => Integrate Oracle with XL

| 3. Oracle CBT with sample GL Accounting System | Download free: http://www.geocities.com/armaghan/

+---------------------------------------------------------------
| SQLPlusPlus now on http://www.ioug.org/

|   "PL/SQL package that extends SQL*Plus to another dimension.

| Contains a PL/SQL code generator and set of extremely useful | utilites with extensive documentation." IOUG Web Site

+---------------------------------------------------------------

Jim <lermontovb_at_hotmail.com> wrote in message news:8ar7pj$h2r$1_at_lure.pipex.net...
> We've got a Trigger on a table which recalculates one field based on a
> change to another (and then updates the other value in the same row),
so
we
> get a :ORA-04091: table WPB.PLAN is mutating, trigger/function may
not see
> it - error (obvious now). We're on Oracle 7.3.
> Anyone know how to get around this one? I think I saw a solution a few
> months ago somewhere but our users want the fix to go in this weekend!
> Thanks
> Jim Gillies

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Mar 17 2000 - 20:31:18 CST