| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: mutating tables?
A copy of this was sent to jennifer spain <jspain_at_arcus.net>
(if that email address didn't require changing)
On Mon, 12 Oct 1998 12:45:39 -0400, you wrote:
>Can't find a word about this one in docs. Seen it?
>
> Oracle Error Code = 4091
>
> ORA-04091: table is mutating,
> trigger/function may not see it ORA-06512: at "", line 2 ORA-04088:
>error during execution of trigger ''
>
>
>Thanks-
its written about in the application developers guide (chapt 9 for v7, chapt 13 for v8)...
basically, in most all cases, you cannot read nor write to the table upon which a FOR EACH ROW trigger is built -- nor can you read or write to tables which has declaritive integrity and are dependent on the table upon which the trigger is firing.
There are a multitude of ways to do things tho, what is it that you are attempting to do?
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Mon Oct 12 1998 - 12:30:18 CDT
 |
 |