CREATE OR REPLACE PACKAGE apex_func
/**
* @PARAM p_string colon delimited string to parse
* @RETURN one coloum table
**/
AS
TYPE tbl_of_varchar
IS
TABLE OF VARCHAR2 (32767);
FUNCTION f_string_to_table(
p_string IN VARCHAR2
)
RETURN tbl_of_varchar PIPELINED;
END apex_func ;
CREATE OR REPLACE PACKAGE BODY apex_func
AS
FUNCTION f_string_to_table(
p_string IN VARCHAR2
)
RETURN tbl_of_varchar PIPELINED
IS
v_temp apex_application_global.vc_arr2;
BEGIN
v_temp := apex_util.string_to_table(p_string);
FOR I IN 1 .. v_temp.COUNT
LOOP
PIPE ROW (v_temp (I));
END LOOP;
END;
END apex_func ;
