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!

PL/SQL Parse bug in Code Outline window?

Graeme DouglasMar 18 2022

(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.
code-outline-error.pngSQLDEV-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.

This post has been answered by Vadim Tropashko-Oracle on Mar 18 2022
Jump to Answer

Comments

Answer

Reproduced, bugged, thank you.

Marked as Answer by Graeme Douglas · Mar 18 2022
1 - 1

Post Details

Added on Mar 18 2022
1 comment
268 views