Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sql plus handling spaces...
<devmcg03_at_gmail.com> wrote in message
news:1153235854.066381.274230_at_s13g2000cwa.googlegroups.com...
> Hi everyone,
>
> I need an answer to a very urgent problem with sqlplus.
> I try to launch (from a Java class) sqlplus or plus80, or plus80w, on
> Win
> NT, with the following command line:
>
>
> sqlplus -s user/password @path\sqlfile1
>
>
> The problem comes when the "path" includes spaces (for example
> c:\program
> files\myapp\sql\).
> In this case sqlplus tries to load the file c:\program.sql !!!
> I discovered that if I use single quotes the problem is solved for the
> command line:
>
>
> sqlplus -s user/password @'path\sqlfile1'
>
>
> But, if the "sqlfile1" calls itself a new sql file like in
>
>
> ...
> @@sqlfile2
> ...
>
>
> which is supposed to use the same path like sqlfile1 (the caller),
> again
> sqlplus tries to find the file c:\program.sql
>
>
> Is there any solution to this problem? Is it possible to load in
> sqlplus a
> file from a directory which has spaces in its name, and this file to
> call
> other files from the same directory (with @@)?
>
>
> I will appreciate any help.
>
Hi,
The simple answer for your very urgent problem is to move the file to a directory without a space in it.
The windoze response would be to use the short (8dot3) filenames so in the
case of "Program Files" use "PROGRA~1"
i.e.
@c:\progra~1\myapp\sql\sqlfile1.sql
not
@c:\program files\myapp\sql\sqlfile1.sql
Good Luck
Ian.
Received on Tue Jul 18 2006 - 10:46:37 CDT