CREATE OR REPLACE
TYPE STRING_TABLE AS TABLE OF VARCHAR2(50);
……

We define the following function in the package RV_TEST:

  FUNCTION collectionInputExampleTable( inputList IN STRING_TABLE) RETURN sys_refcursor AS
    tableCollection STRING_TABLE:=STRING_TABLE();
    retCur sys_refcursor;
  BEGIN
    
    FOR i IN 1..inputList.count LOOP
      tableCollection.extend(1);
      tableCollection(i):=inputList(i);
      --outputList(i):=inputList(i);
      --DBMS_OUTPUT.put_line('ELEMENT:'||inputList(i));
    END LOOP;
    
    OPEN retCur FOR SELECT * FROM TABLE (tableCollection);
    
    return retCur;
    
  EXCEPTION WHEN OTHERS THEN
      txnvs_db_util.tx_log( 3, 2, SQLCODE, SQLERRM, null );
      RAISE;
  END collectionInputExampleTable;