RE: sqlplus and spaces in path

Use the DOS "8.3" filename format. You can see what I mean with a
"dir/x" command from DOS. Instead of "C:\Documents and
Settings\whatever", you'd use "c:\docume~1\whatever".

 

Cary Millsap

Hotsos Enterprises, Ltd.

http://www.hotsos.com

Nullius in verba

 

Hotsos Symposium 2008 / March 2-6 / Dallas

Visit www.hotsos.com for curriculum and schedule details...

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sam Bootsma
Sent: Wednesday, August 22, 2007 9:34 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: sqlplus and spaces in path

 

Hello All,

 

I am on Oracle database 10.2.0.3.  My sqlplus version is 10.1.0.5.0.

 

I have a sql script in a directory with embedded spaces (for example,
directory C:\Documents and Settings\Staff\My Documents\_a).  This sql
script includes a couple of calls to other sql scripts using @@.  For
example:

....
@@sqlfile2
....

I can call my main sql script by enclosing the path and file name in
single or double quotes.  But when this sql script calls another script
using @@ (eg. @@sqlfile2), sql plus returns an error like:

 "SP2-0310: unable to open file "C:\Documents.sql"

 

Is there any solution to this problem?  Is it possible to load into
sqlplus a script from a directory which has spaces in its name, and this
file to call other files from the same directory with @@)?

 

Thanks for any suggestions!

 

Sam Bootsma

Oracle Database Administrator

Information Technology Services
George Brown College

Phone: 416-415-5000 x4933
Fax: 416-415-4836
E-mail: sbootsma@xxxxxxxxxxxxxx <mailto:sbootsma@xxxxxxxxxxxxxx>

Other related posts: