Re: How to run a script in winXP

"Peter Shankey" <oxmard.Rules_at_ab.ab> wrote in message news:<fvWcnftPUoZW1sujXTWcog_at_comcast.com>...
> I am on a winXP system running SQL+ 9.2.0.1.0.
>
> It seems the SQL+ has a problem with spaces. Is there a method to allow one
> to type in a path with spaces and run the script??
>
> Pete
>
>
>
> SQL>
> SQL>
> SQL> _at_C:\Documents and Settings\shankeyp\My
> Documents\ora\wip\perl\load_customers
> SP2-0310: unable to open file "C:\Documents.sql"
> SQL> _at_C:\"Documents and Settings"\shankeyp\"My
> Documents"\ora\wip\perl\load_customers
> SP2-0310: unable to open file "C:\"Documents.sql"
> SQL> _at_C:\'Documents and Settings'\shankeyp\'My
> Documents'\ora\wip\perl\load_customers
> SP2-0310: unable to open file "C:\'Documents.sql"
> SQL>
> SQL>
>
> SQL> select banner from v$version;
>
> BANNER
> ----------------------------------------------------------------
> Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
> PL/SQL Release 9.2.0.1.0 - Production
> CORE 9.2.0.1.0 Production
> TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
> NLSRTL Version 9.2.0.1.0 - Production
>
> SQL>
Enclose it inside "" e.g. SQL> _at_"C:\Program Files\Blah.sql"

Regards
/Rauf Sarwar Received on Sat Feb 22 2003 - 01:44:59 CET