| sqlplus: path with spaces [message #342092] |
Thu, 21 August 2008 05:40  |
123soleil
Messages: 35
Registered: July 2006
|
Member |
|
|
Hello,
I have the following script (launch_install.sql) that I am trying to execute:
exec script.prepare_install;
@c:\my project\install.sql;
exit;
I am using sqlplus under windows. The problem is that i get an error message "unable to open file 'my.sql'". sqlplus thinks the command line finishes with the first blank. I've tried single and double quotes to no avail.
Is there a solution?
Thanks
|
|
|
|
| Re: sqlplus: path with spaces [message #342115 is a reply to message #342092] |
Thu, 21 August 2008 06:53  |
 |
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
It works with double-quotes:
SQL> @"C:\Program Files\t.sql"
SYSDATE
-------------------
21/08/2008 13:52:17
1 row selected.
But SQL*Plus doesn't like space in file names, you should avoid it and change your directory name.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
