unsupported use of WITH clause error when using a “with function” SQL statement
I am trying to use the function using the WITH clause and I am getting an ORA-32034 error on APEX versions 18.1 and above. This issue persisted while upgrading the apex application to version 20.1.
Cause with while writing through SQL/PLSQL: Improper use of WITH clause because one of the following two reasons:
1. nesting of WITH clause within WITH clause not supported yet
2. For a set query, WITH clause can’t be specified for a branch.
3. WITH clause can’t be specified within parentheses.
Resolution With Oracle APEX:
Add an optimizer Hint at the below location, instead of writing inline with SQL query.