Does anyone know if it is possible for APEX to call a SQL procedure, let it do all the magic, and then return the values needed to create a multiple selection radio group?
We have a procedure created that APEX uses to populate hidden page items, and then SQL is written on the radio group within APEX to create the selections. However, the query is getting too long for APEX. So, we thought it might be possible to do it all on the SQL side and just pass into APEX what is needed for the radio group selection.
Hope this makes sense.