Small APEX Intermezzo (apex_string.plist_put)

1 min read
A small Oracle APEX intermezzo about apex_string.plist_put. Its kind of a weird set of functions/procedures where keys and values are put in one long apex_t_varchar2. The first key is put in slot 1, the first value is put in slot 2, etc …
declare
l_apex_templates apex_t_varchar2 := new apex_t_varchar2();
l_clob clob;
begin
apex_string.plist_put(l_apex_templates, 'REGION', 'apex_240100.wwv_flow_page_plug_templates');
apex_string.plist_put(l_apex_templates, 'PAGE', 'apex_240100.wwv_flow_templates');
apex_string.plist_put(l_apex_templates, 'REPORT', 'apex_240100.wwv_flow_row_templates');
apex_string.plist_put(l_apex_templates, 'LIST', 'apex_240100.wwv_flow_list_templates');
apex_string.plist_put(l_apex_templates, 'LABEL', 'apex_240100.wwv_flow_field_templates');
apex_string.plist_put(l_apex_templates, 'BUTTON', 'apex_240100.wwv_flow_button_templates');
apex_string.plist_put(l_apex_templates, 'MENU', 'apex_240100.wwv_flow_menu_templates');
apex_string.plist_put(l_apex_templates, 'CALENDAR', 'apex_240100.wwv_flow_cal_templates');
apex_string.plist_put(l_apex_templates, 'POPUP_LOV', 'apex_240100.wwv_flow_popup_lov_template');
for l_idx in l_apex_templates.first .. l_apex_templates.last / 2 loop
dbms_output.put_line(' "idx" = ' || l_idx || --
' key = ' || rpad(l_apex_templates(l_idx * 2 - 1), 10, ' ') || --
' value = ' || l_apex_templates(l_idx * 2));
end loop;
end;
/
0
Subscribe to my newsletter
Read articles from Mark directly inside your inbox. Subscribe to the newsletter, and don't miss out.
Written by
