Create clob_to_table

[martindsouza]

Similar to string_to_table but only takes in p_clob and the piped row is of type clob. See #32 for example

[martindsouza]

What should we call this? clob_to_table, string_to_table_clob? Name may determine where it actually resides (in oos_util_string or oos_util_lob).

[janihur]

Just a clarification. Is this issue about a clob counterpart of this oos_util_string subprogram ?

  -- package: oos_util_string
  function string_to_table(
    p_string in clob,
    p_delimiter in varchar2 default gc_default_delimiter)
    return tab_vc2_arr;

As lob manipulating subprograms in Oracle are in a dedicated package (dbms_lob) my first idea is to keep also here all lob manipulating subprograms in a dedicated package (oos_util_lob).

Suggested subprogram signature:

  -- package: oos_util_lob
  type tab_clob is table of clob;
  function string_to_table(
    p_string in clob,
    p_delimiter in varchar2 default gc_default_delimiter)
    return tab_clob;

Other comments

In other programming languages these subprograms are usually known as split (Ruby and .NET examples) and the return value is a list and not an associative array. However I see the current terminology is identical to APEX and it might be a valuable idea to keep names consistent. I don't know as I have never used APEX ;)

I suggest all types to be declared in a dedicated package, e.g. oos_type as the types are likely useful also in other contextes without oos_util_string or oos_util_lob.