APEX Report with SQL using WITH clause function gives error.

Summary:

Below query works fine in APEX SQL Workshop, but gives error (ORA-32034: unsupported use of WITH clause) when creating an APEX Interactive report.

with FUNCTION with_function(p_id IN NUMBER) RETURN NUMBER IS

 BEGIN

  RETURN p_id*5;

 END;

SELECT with_function(5)

FROM  dual

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):