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

open Cursor_Name;
loop
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.

Shyeah

Manowar Bio

In Flames Bio