oracle apex tabular form MRU process
<p>I have a tabular form based on a simple sql like </p>

<pre><code>select col1, col2, check_box from view1
</code></pre>

<p>users can update the check_box in the form, and col1 and col2 will be manipulated based on whether the check_box is checked or not. Then the base table will be updated in the DB by the MRU process I created.</p>

<p>The issue I have is, besides updating the base table using MRU, I also want to call another proc to do something else based on check_box in the form</p>

<p>e.g. </p>

<pre><code>if check_box is unchecked, then col1 and col2 will be blanked by the MRU;
if check_box is checked, col1 and col2 will be updated to 'Done' by the MRU,
also a proc should be called to do something else.
</code></pre>

<p>My question is, should I stick with the MRU approach(as MRU has its upside including lost update detection, locking etc...), and create a seperate process to to call the proc, or should I just create a process that does both (something like looping through each line of the report, update the base table and when the check_box is checked, call the proc)?</p>

<p>what would be the better apporach?</p>