It seems that we could only create such view with
SQL*Plus, but not with PLSQL Developer.
CREATE OR REPLACE VIEW test$v AS
WITH
FUNCTION with_function(p_id IN VARCHAR2) RETURN VARCHAR2 IS
BEGIN
RETURN p_id;
END;
SELECT with_function(dummy) AS dummy
FROM dual;
/
This gives this error :
- ORA-06553: PLS-103: Encountered the symbol "end-of-file"
I've tried with SQL window, command window and program window.
Note:
Post on Stack Overflow