The code belong works perfectly - but - how can I adapt it to include a sort sequence? Meaning, if I have selected 5 rows, and they have columns for DISTRIB_NMBR and DISTRIB_DATE, I want the procedure to run the oldest distributions first (using either Distrib_nmbr or Distrib_date)
Thank you
mt in NY
DECLARE
P_DISTRIBID NUMBER;
P_APP_SESSION NUMBER;
BEGIN
for x in 1..apex_application.g_f40.count
loop
SPDISTRIB_INVESTOR_INS(
P_DISTRIBID => apex_application.g_f40(x),
P_APP_SESSION => :APP_SESSION
);
--rollback;
END LOOP;
END;