Just upgraded to 25.1 and immediately ran into a thousand errors when logging in.
Narrowed it down to the fact that when running a script using an OS environment variable fails.
(Working on windows 11)
spooling to a file, using the same variable is no problem at all.
This functionality worked without any issues pre-25.1.
Running this:
version
host echo %temp%
spool %temp%\TestScript.sql
prompt -- test script to see if I can access it using environment variables
prompt select 'Result of the query in the testscript' as result
prompt from dual
prompt /
spool off
host type %temp%\TestScript.sql
@%temp%\TestScript.sql
Everything works fine pre-25.1, but in 25.1 the last statement failes with
SP2-0310: Unable to open file: "%temp%\TestScript.sql"
25.1:
24.2:
