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!

SQLcl from SQL Developer for VS Code (25.3.0) sets SQLPATH incorrectly.

Markus Weber43 hours ago

hello @all,

When you configure the Startup Script Path in SQL Developer for VS Code (25.3.0), the specified script runs as expected.

settings.json:

"/Users/markus/Work/workspace/oracle/sql/login_vscode.sql"

However, if you now open SQLcl from SQL Developer for VS Code (25.3.0), it doesn't work that way.
Instead, the environment variable SQLPATH is set to the Startup Script, which looks nice but doesn't function correctly.

current output:

expected output:

If I configure the Startup Script Path to specify only the directory instead of a file, the login.sql script located in that path is not executed in SQL Developer for VS Code (25.3.0). However, when I start SQLcl from SQL Developer for VS Code (25.3.0), the environment variable SQLPATH is set to the Startup Script Path, and the login.sql script is executed.

Is there a way to configure it so that both SQL Developer for VS Code (25.3.0) and the SQLcl executed from there work correctly?

regards

Markus

Comments
Post Details
Added 43 hours ago
1 comment
38 views