Small APEX Intermezzo (apex_string.plist_put)

MarkMark
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

Mark
Mark