Hi APEXperts,
Is there a way to execute a package procedure "only once" before/after grid Interactive Grid - Automatic Row Processing (DML) ?
When I tried Type = "Execute Code" and Editable region assigned, the package procedure is being called for every modified/created row.
One workaround I could think of is to use global variable in the package procedure to execute it only once.
IF NOT g_already_executed THEN
-- do my process logic
-- set the global variable to true
g_already_executed := TRUE;
END IF;
But I would like this to be possible within APEX framework without the need for workarounds.
Assuming this is not possible using APEX provided processes already, I have posted this as an feature request. If this is not possible OOTB from APEX and if you too happen to run into this use case, you can up-vote the idea.
https://apexapps.oracle.com/pls/apex/apex_pm/r/ideas/details?idea=FR-2075
Thanks