(SQL Developer Version 21.4.3.063 / Microsoft Windows [Version 10.0.19042.1586])
I think this a bug in the parsing for the Code Outline window, something I use all the time for navigating within large package files.
Details: The Code Outline window parse tree reports 'Syntax error; partial parse tree' when using WHERE CURRENT OF
with a cursor in another package. e.g. where current of
pkg1.
c1
Note that WHERE CURRENT OF <cursor>
is fine, it seems to be <package>.cursor that causes the problem.
Screenshot below, showing that SQL Developer incorrectly thinks this is an error. Sample code to reproduce attached.
SQLDEV-bug-where-current-of-package-cursor.txt (1.08 KB)This sample code compiles and runs with no problem:
Table TEST_TAB dropped.
Table TEST_TAB created.
1 row inserted.
Commit complete.
Package PKG1 compiled
Package PKG2 compiled
Package Body PKG2 compiled
PL/SQL procedure successfully completed.
TEST_KEY TEST_VAL
---------- --------------------
AA x
I would be grateful for any insight into this problem, thanks.