ORA-04091 - PL/SQL sleep procedure

Good afternoon.

I have run into the venerable mutating tables error, and I have been on the internet and read the documentation, and fixed the problem. When I changed the trigger so that it no longer referenced the table being updated, it caused another problem with our employee timesheets. So, I had to put the code back into place, mutating tables be damned.

What I am trying to do is this: I simply want to do a select count(*) statement to count the number of records matching several constraints. Unfortunately, this table is in the process of being updated by yet another trigger, hence the mutate table error.

Is there a way to tell if the offending trigger has completed firing, and committed its changes? If not, is there a PL/SQL equivalent of the sleep command? If there was a way to make the select statement wait until all previous modifications are complete, it would make my life a whole lot easier.

Thanks in advance.

Ned Wilson
In-House Developer
Business Data Services, Inc. Received on Sat Jun 27 1998 - 00:00:00 CDT