Skip to Main Content

SQL Developer

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!

Bug? Inline functions, multiple queries, and F9

2826473Jul 14 2021

Version 20.4.0.379, Windows 10, 12c database.

If I have a worksheet up, and the following two queries in that worksheet...

SELECT 2 FROM DUAL;

SELECT 3 FROM DUAL;

...I can place my cursor on/within either line, and execute the corresponding query by pressing F9.

However, if the first query includes an inline function (WITH clause invoking a PL/SQL function), SQL Developer loses the distinction between queries when I try to F9 from within either.

WITH FUNCTION f (p_n IN NUMBER) RETURN NUMBER AS BEGIN RETURN (p_n * p_n); END f;
SELECT f(2) FROM dual;

SELECT 3 FROM dual;

Now when I place my cursor within either and press F9, I get ORA-00933: SQL command not properly ended.

This post has been answered by KayK on Jul 15 2021
Jump to Answer
Comments
Post Details
Added on Jul 14 2021
1 comment
103 views