Hello,
I have a shuttle item on a page.
I need to update a table with this shuttle's values. How do I do that, please?
I already have an Automatic Row Process on this page, updating other table.
The shuttle is in a separate region, using data of a different table.
Here is the code of the right shuttle's column, which has to be populated into a table:
declare
v_list apex_application_global.vc_arr2;
begin
select profile_name return_value
bulk collect
into v_list
from profiles p, user_profiles u
where p.profile_id = u.profile_id
and u.user_id = :p61_user_id;
return (apex_util.table_to_string (v_list));
end;
I suppose, it can't be an automatic process?
Shall I create a PL/SQL process to update the table, and what would be the code?