APEX

Hi,

I have a form that is used to calculate the volume of a (large) number of tanks based on entered tank heights.

I have a PL/SQL procedure that performs the calculation - it is given the name of the tank and the height and calculates the volume (each tank may have different physical characteristics).

I didn't want to create a Dynamic Action per tank (I'm lazy and the number of tanks is large!). I currently have a Dynamic Action that is triggered whenever any of the tank heights on the form change. The action PL/SQL calls the calculation for each tank. E.G.

:P1_TANK1_VOL := tank.vol('TANK1', :P1_TANK1_HEIGHT);
:P1_TANK2_VOL := tank.vol('TANK2', :P1_TANK2_HEIGHT);
...
:P1_TANK50_VOL := tank.vol('TANK50', :P1_TANK50_HEIGHT);

This works but involves performing 50 calculations whenever a single one is required and can appear to be slow.

Is there a way to identify the triggering element from the PL/SQL action? E.G.

IF TriggeringElement = 'P1_TANK1_HEIGHT' THEN
:P1_TANK1_VOL := tank.vol('TANK1',:P1_TANK1_HEIGHT);
END IF;

Any ideas?