Having problems when running from QSR a sql file with relative paths.
When launching a file from toad and selecting Editor | Execute SQL via QSR, QSR is not recognising the relative path.
You get the error:
"Open spool file "log/test3.txt"
<file_error msg="The system cannot find the path specified." n="3"/>"
If you type the full path then it works.
Example of code do not working:
SET SERVEROUTPUT ON
SPOOL log/test3.txt
select sysdate from dual;
spool off
Example of code working:
SET SERVEROUTPUT ON
SPOOL c:/log/test3.txt
select sysdate from dual;
spool off
This was working on previous versions.
WORKAROUND
1- Modify the scripts so they use the full path
2-Open the files directly from QSR
3-Use Toad For Oracle 11.6 (you can install it side by side your 12 installation if needed)
STATUS
Waiting for fix in a future release of Toad for Oracle
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center