Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TYPE TP_BI_LIST AS TABLE OF VARCHAR2(4000);
CREATE FUNCTION FNBIGB_CheckDataMissing2 (
  pOwn IN VARCHAR2,
  pTab IN VARCHAR2,
  pCol IN VARCHAR2
) RETURN NUMBER
IS
  v_str     VARCHAR2(2000); 
  v_results TP_BI_LIST;
BEGIN
  v_str := ' SELECT ''TEST1'' AS NM_COLUMN FROM DUAL UNION ALL
             SELECT ''TEST2'' AS NM_COLUMN FROM DUAL UNION ALL
             SELECT ''TEST3'' AS NM_COLUMN FROM DUAL';

  EXECUTE IMMEDIATE v_str BULK COLLECT INTO v_Results;

  DBMS_OUTPUT.PUT_LINE('Total rows: '||v_Results.COUNT);       

  IF pCol MEMBER OF v_Results THEN
    dbms_output.put_line('YES');
  ELSE
   dbms_output.put_line('NO'); 
  END IF;
  RETURN 1;
END;
/
DECLARE
  val NUMBER;
BEGIN
  val := FNBIGB_CheckDataMissing2( NULL, NULL, 'TEST1' );
  dbms_output.put_line( val );
END;
/
1 rows affected

dbms_output:
Total rows: 3
YES
1