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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
34 views