985553 wrote:Bad idea? A bit of an understatement. ;-)
So basically, you would deem it a bad idea, and the same information should just be communicated to the user by report based on an sql query?
select nvl(max(Volunteers_currently_signed_up),0) into v_signed_up from volunteers where project_id=:new.project_id;This code is not thread-safe.
v_signed_up:=v_signed_up+1;..other transactions (same project) could have committed and changed the signed up volunteer total. Which means your calculate-the-count statement is now using the wrong total.