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.
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
/