Re: Selecting while table is updating

From: David <darussell_at_email.msn.com>
Date: 1998/03/14
Message-ID: <#2XQf02T9GA.292@upnetnews02.moswest.msn.net>#1/1

If you want to requery the table while it is mutating then you will have to perform the select on a after statement trigger, rather than row level triggers.

Regards
David Russell
Kreiser wrote in message <350906c9.0_at_192.168.1.110>...
>I want to select datasets from a table inside a trigger, but this
>table is currently being updated.
>Oracle shows the following error: ORA-04091.
>Can anybody help me?
>
>Please send answers to:
>kreiser_at_dvse.de
>
>Thanks,
>Dirk Kreiser
>
Received on Sat Mar 14 1998 - 00:00:00 CST