If I am understanding your?? correctly you want to insert a single row with values 74:128:84 instead of 3 rows, one for each task id ?.
The error you are getting is bcaz the column TASK_ID is most likely defined as a number and having " : " in the value is making it alphanumeric so datatype mismatch.
Change the task_id column to character datatype and insert should work.
If you can tell me where is this shuttle list used e.g. oracle form, web page etc... then I can perhaps guide you on an appropriate solution.
Never mind, I got a solution to insert the data. Here below is the code. Now i need to do the same for update and delete, could you guide me?
l_vc_arr2 := APEX_UTIL.STRING_TO_TABLE(:P287_TASK_ID);
FOR z IN 1..l_vc_arr2.count LOOP
INSERT INTO NETSEC_ENGINEER_TASKS (ID, ANALYST_ID, TASK_ID)
VALUES (:P287_ID, :P287_ANALYST_ID, l_vc_arr2(z));