Re: Mutating Error on a row-level trigger.

Steven Markey wrote:

> I have 2 tables:
>
> <post snipped>
>
> So, any thoughts on were I am going wrong? I double-checked the SQL in my
> queries and cursor and nothing jumps out at me.... Also, what's the better
> approach?

I'm with Jim. This is a good use for a materialized view or DBMS_JOB. I would only implement this using triggers if I was forced into a real-time environment and had some reason why a materialized view wouldn't work.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
http://www.outreach.washington.edu/extinfo/certprog/aoa/aoa_main.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)