Hi,
I have a complex problem.
I am having trouble with triggers in Oracle.
I have Table a (parent) and Table b (child).
I want to update a certain column in the parent table, after each delete in the child, by querying all the instances of the parent in the child table. (patient (parent) - study (child) i.e. for each patient there are a number of studies).

I have a trigger after delete on the child table that triggers an update on the parent table at a certain column (which is composed of all child instances for that specific row in the database).

I keep getting ORA-04091 errors because i am performing a select on the table from which the trigger was fired.

What do i do ???

Thanx
Rotem.