APEX配列からJSON配列への変換

apex-array-to-json-array.sql

declare
    l_json_array json_array_t := new json_array_t();
    l_apex_array apex_t_varchar2;
begin
    l_apex_array := apex_string.split(:P3_SKILLS,':');
    for i in 1..l_apex_array.count
    loop
        l_json_array.append(l_apex_array(i));
    end loop;
    :P3_SKILLS := l_json_array.to_string;
end;