3.4 Converting an Array to a Single Value

You can also use Oracle Application Express public utility functions to convert an array into a single value. The resulting string value is a colon-separated list of the array element values. For example:

htp.p(APEX_UTIL.TABLE_TO_STRING(APEX_APPLICATION.G_F01));

This function enables you to reference G_F01 to G_F50 values in an application process that performs actions on data. The following sample process demonstrates how values are inserted into a table:

DECLARE
  l_buffer VARCHAR2(4000);
BEGIN
  l_buffer := APEX_UTIL.TABLE_TO_STRING(APEX_APPLICATION.G_F01);
  INSERT INTO my_table (my_column) VALUES (l_buffer);
END;