Home » SQL & PL/SQL » Client Tools » sqlplus: path with spaces (sqlplus)
sqlplus: path with spaces [message #342092] Thu, 21 August 2008 05:40 Go to next message
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 Go to previous message
Michel Cadot
Messages: 64108
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Is SPAM admin tool a Oracle product?
Next Topic: Isidian Technologies - Does the company still exist?
Goto Forum:
  


Current Time: Mon Dec 05 04:50:32 CST 2016

Total time taken to generate the page: 0.09421 seconds