Skip to Main Content

SQL Developer for VS Code

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: Error line number incorrect on Problems tab

Eric Olson 1Apr 30 2025

I find the line number reported on the Problems tab can be incorrect. Scenario: I have a top-level script that calls various DDL files with @-commands. If I run a command in the top-level script and the DDL file contains an error, the line number reported appears to be (line in the script that calls the DDL file) + (line in the DDL file itself).

For example, myscript.sql line 66 contains “@mypackage.pkb” and mypackage.pkb has an error on 1529. The Problems tab says:

PLS-00302: component 'SBFL_CURRENT' must be declared C:\Path\To\myscript.sql [Ln 1582, Col 67]

And the Script Output tab says:

1517/67   PLS-00302: component 'SBFL_CURRENT' must be declared

Line 1517 + line 66 = line 1583 (ok, it's off by one) Note the column number is correct.

Comments
Post Details
Added on Apr 30 2025
0 comments
101 views