Re: sqlplus not allowing spaces

From: gazzag <gareth_at_jamms.org>
Date: 18 Jul 2006 08:37:06 -0700
Message-ID: <1153237026.127257.135130@p79g2000cwp.googlegroups.com>

> devmcg03_at_gmail.com wrote:
> > I'm on win2003 with Oracle 10.1 server
> >
> > It seems the SQL+ has a problem with spaces. I am trying to run a
> > script that contains the Program Files directory in it's path. I am
> > getting errors and I was hoping someone here might have a suggestion to
> > get this to run. I've tried enclosing the path in single and double
> > quotes but that's not working. Any suggestions?
> >
> >
> > *not working*
> > @C:\Program Files\scripts\test.sql
> > @'C:\Program Files\scripts\test.sql'
> > @"C:\Program Files\scripts\test.sql"
> >
> >
> > SP2-0310: unable to open file "C:\Program.sql"
> >
> >
> > dave
>

Apart from Sybrand's correct suggestion, you could CD to the correct directory from a command-prompt and run the relevant script from the DOS SQL*Plus client.

HTH -g Received on Tue Jul 18 2006 - 10:37:06 CDT