Can SQPATH be changed from within PL/SQL Developer?

[MjH]

The SQLPATH environment variable has an interesting feature. It can be (in Windows) a semi-colon separated list of directories. e.g. SET SQLPATH=c:\dir1;c:\dir2;c:\dir3

When you run a file with @ in the Command Window, each of the directories is searched, in order, and the first file found is run.

Now, this means you either have to have SQLPATH set in the Windows environment variable set up, or run a CMD window, do the set of SQLPATH, then start PL/SQL Developer from the CMD window.

If you want to change SQLPATH, this means you have to exit PL/SQL Developer, change the variable and then start up PL/SQL Developer again. Is there a way to change SQLPATH from within PL/SQL Developer so that a new Command window would look at a different set of directories without having to restart PL/SQL Developer?

I am guessing the answer is no, but I thought I would ask.

 

[Marco Kalter]

It is currently not possible to dynamically set an environment variable from within PL/SQL Developer. I have added this to the list of enhancement requests as a new command for the Command Window.

At the moment you can only statically set environment variables for PL/SQL Developer in the Params.ini file. For example:

ENV:SQLPATH=c:\dir1;c:\dir2;c:\dir3

This limits the scope of the environment variable to the PL/SQL Developer process, but it cannot be changed without restarting PL/SQL Developer.

 

[MjH]

Thanks, Marco. I thought that would be the case. Thanks for putting it on the list of enhancement requests.