Mutating table problem. Help?

From: Clint Fell <pyrotech_at_dave-world.net>
Date: Mon, 13 Sep 1999 21:30:24 -0500
Message-ID: <37DDB340.16DD2056@dave-world.net>

Greetings. I couldn't find anything in the group regarding this, though I expect its probably been asked before. So please hear me out.

Here's my situation. I've created these triggers on table A for after update, delete and insert on that table. The triggers themselves select some data from table A and insert it into table B, which has no relations to or from table A. I get the mutating table error.

All of my Oracle manuals agree that one cannot update a table that the trigger is on, in that trigger, but I'm only doing a select. 1/2 of my books specifically say I can do a select, 1/2 say I can't. Which is true, and if I can't do a select, do I have another option here?

Thanks.

-Brian Day

whitewlf_at_bigbrother.net

-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==---------- http://www.newsfeeds.com The Largest Usenet Servers in the World!
------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==-----
Received on Mon Sep 13 1999 - 21:30:24 CDT