The execution of any SQL script in the SQL Editor Window, via the "@" (at sign) command, fails with the following OS error message:
"Unable to read <file_name>
@<file_name>"
RESOLUTION #1:
Include the path to the file in the command.
For example, if the file_name.sql file is in the C:\Toad directory.
Instead of...
@file_name.sql
...use...
@C:\Toad\file_name.sql
RESOLUTION #2
1) Right click on the Toad shortcut and select Properties.
2) In the 'Start in' field, change the value to where the file is located.
By doing this, Toad will now know which directory to look in for the file being run. However, this could cause issues with another feature in Toad, if Toad needs to find a file in the original directory listed. Since the value was changed, it could no longer find that original file.
