Objective: Click a Button and make all possible items in a Popup LOV Page Item be selected.
APEX 24.2 Page Item of type Popup LOV, multiple values, ':' delimited and trying to use DA associated with a Button to cause all possible matches to be selected in the Page Item. The DA does a select into the Page Item using the same criteria as the Popup LOV, generates a ':' delimited list into the Page Item but then errors with "ORA-01722:invalid number" when existing the DA PL/SQL procedure. Tried using Debug but not enough information in the error detail to nail the problem down, same with reviewing the console. It seems to error after exiting the PL/SQL DA code. SQL is below. Can I assign multiple values to the Popup LOV like that? Debugging shows the resulting value looks like 2152:3450, which is correct.
Select ListAgg(Ben_Group.SY_Associations_ID, ':') Within Group (Order By Ben_Group.SY_Associations_ID)
Into :P109_BEN_GROUP_SY_ASSOCIATIONS_ID_LIST
From VW_EPRPlan_Benefit_Groups Ben_Group
Where Ben_Group.EPRPlanLink_ID = :P109_EPRPLANLINK_ID
And :P109_EXPIRE_AS_OF < BG_Expires
Order By BG_Expires Desc, BG_Effective Desc ;