I have a sql script that does some spooling: c:\spool_test\run.sql
SPOOL output.txt
SELECT * FROM DUAL;
SPOOL OFF
When I open the run.sql file and execute, it outputs as expected.
When I run (as statement or script) with @c:\spool_test\run.sql in a worksheet, I see the select-results in the script output but I get no file (or at least not one in spool_test, nor does output.txt come up in a file search) and I get no error/warning. If I add the directory to the spool, it works. My assumption is without a directory, it's defaulting to some directory I don't have write-permissions on, instead of the directory of the script. Is this expected? I don't have a working version of SQL Plus handy on my work machine so I haven't been able to compare.