Re: sql plus handling spaces...

try placing the SQL scripts in your Oracle BIN directory

george

devmcg03_at_gmail.com wrote:
> 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 Mon Jul 31 2006 - 13:53:13 CDT