Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"ORA-32034: unsupported use of WITH clause" related.

currently using 19c in ATP, oracle Database Actions Tool.

WITH
  FUNCTION with_function(p_id IN NUMBER) RETURN NUMBER IS
  BEGIN
    RETURN p_id;
  END;
SELECT with_function(id)
FROM   t1
WHERE  rownum = 1
/

o/p
ORA-32034: unsupported use of WITH clause

Comments
Post Details
Added on Dec 8 2021
2 comments
83 views