Is there still no way to get the non-gui sqlplus to point to a different directory without stopping and restarting it? I'm using a Windows 7 64-bit platform. The old plusw easily changes using the file/open process.
I have to support multiple schemas and incremental changes to each, and the changes come in the form of sqlplus scripts, easily run with the scripts using @scriptname. These often are grouped in different directories, so I want to switch to a new directory, run several scripts, then off to another directory. The same steps are then run after logging into a different schema.
We also have dozens of batch jobs that run a series of sqlplus scripts, and testing in the Windows environment requires running out of a directory set up like the batch environment.
It is a real pain to enter the directory path before the script name each time. Even a cmd.exe window permits the cd command, but "Host cd..." from sqlplus doesn't achieve what we need. Any suggestions?