Creating a view with a function in a with clause does not work even if "AutoSelect statement" is disabled. Not even in the command window.

We have to use SqlPlus to compile such view.

Code
CREATE OR REPLACE VIEW TMP_FUNCV AS
WITH 
  FUNCTION FOO RETURN NUMBER IS
  BEGIN
    RETURN 1;
  END;
  FUNCTION FOO2 RETURN NUMBER IS
  BEGIN
    RETURN 2;
  END;
SELECT FOO,FOO2 FROM DUAL
/