declare l_vc_arr2 apex_application_global.vc_arr2; begin select category_id bulk collect into l_vc_arr2 from movies_categories where movie_id = :P3_ID order by 1; :P3_CATEGORIES := apex_util.table_to_string ( p_table => l_vc_arr2, p_string => ':' ); end;