title: Easy way to insert select list data in Oracle Apex PL/SQL code?
body: <p>I have a form with a select list, where the user can select anywhere from 1 to 50 options, basically, my PL/SQL code first creates an "event", that is only one item, however then, I want to create associations of that event with "services" of which there can be several selected. So I need something akin to a loop to do this.</p>
  
  <p>One other issue is that when I select multiple items in a select list or checkbox, the value that comes in is something like "1:5:3:4:8", so I if there is a better way than writing a function to split, add all them to an array and then loop on the array and add each one of these id's individually. I feel like I have the wrong approach.</p>