with function text2date(p_test varchar2) return date
as
    v_res date;
begin
    execute immediate 'select ' || p_test || ' from dual' into v_res;
    return v_res;
exception
    when others then
        return null;
end text2date;
select text2date(q'{to_date('01.11.2019','dd.mm.yyyy')}') x from dual;