I have a APEX app (previously on v4.1.1) that has been imported into v22.2 and I have the following code;
DECLARE
l_selected APEX_APPLICATION_GLOBAL.VC_ARR2;
BEGIN
--
-- Convert the colon separated string of values into
-- a PL/SQL array
l_selected := apex_util.string_to_table(:P65_lobby);
--
-- Loop over array to insert interest_shuttle_data
--
FOR i IN 1..l_selected.count
LOOP
INSERT INTO pod.pod_data_list_jobs (job_ref_number, selection_item,order_item, selection_values,address_source)
VALUES (:P65_JOB_NUMBER,'p65_lobby',box_direct_data_list_job_seq.nextval, l_selected(i),'PO_BOX_DIRECT');
END LOOP;
END;
The expected result is a count of records, but it returns 0 for the count. I've seen online that “apex_util.string_to_table” is now deprecated, but if I try using alternative “apex_string.split”
P65_LOBBY is a shuttle item of LOBBY names.
Any help would be appreciated. Thanks