Re: Mutating table problem. Help?

A copy of this was sent to Clint Fell <pyrotech_at_dave-world.net> (if that email address didn't require changing) On Mon, 13 Sep 1999 21:30:24 -0500, you wrote:

>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?
>

you cannot select from the table the trigger is defined on in the ROW triggers.

See my signature for a URL to a paper on howto avoid mutating table errors.

>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 ==-----

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Sep 14 1999 - 09:14:20 CDT