thanks for the quick response. Looks like I'm going to have to change
the path to be c:\progra~1. That does the trick!
Ian M wrote:
> <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 - 11:20:44 CDT
