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));
For update or delete i think you can reuse the loop logic but execute delete or update instead of Insert.
How are you going to trigger upd versus delete or even insert, are you going to provide 3 separate buttons or some gui object
You have 2 option. that is you can delete all related record outside the loop and then insert.
or use merge statement not insert.