An alternate solution to The Cursor Problem is to use a normal loop as

open Cursor_Name;
fetch Cursor_Name into Variable1, ....;
exit when Cursor_Name%notfound;
end loop
close Cursor_Name;

Every fetch from the cursor increments an imaginary row pointer if you will, and the exit conditions is true when Cursor_Name fetches nothing, ie all rows are processed.

For The Trigger Problem I should be using before update not after update.

My bad.

Btw In Flames is a swedish band and Manowar's guitarist was originally part of a Sabbath backup band.


Manowar Bio

In Flames Bio