Re: Mutating table problem. Help?

You cannot select from the table in one of its triggers.

The work around depends on what you want to do. So tell us more.

Clint Fell a écrit dans le message <37DDB340.16DD2056_at_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 Tue Sep 14 1999 - 03:01:28 CDT