You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

APEX Report with SQL using WITH clause function gives error.

Accepted answer
23
Views
2
Comments

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):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!