Skip to Main Content

SQLcl: MCP Server & SQL Prompt

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!

Windows Variable for Scripts Ex: @%Proj%\script1.sql

TedLfromFLApr 24 2025

Hello SQLcl Team,

We have a set of Windows environment variables to handle file locations. For example, Proj=\\server10\project2 in the windows environment. Then we have been able to build command line scripts to run in SQLcl, @"%Proj%\script1.sql". This has made it so as our server and share names move, we only need to change the environment variable.

This worked very well in build: 24.4.1.042.1221. In 25.1.0.101.2353, we have found that SQLcl wants to translate the %Proj% literally and does not translate the %variable% to the environment variable's value.

Is there an option in the settings to restore the %variable% functionality?

Thank you,

Ted L.

Comments
Post Details
Added on Apr 24 2025
1 comment
90 views