How to run a script in winXP
From: Peter Shankey <oxmard.Rules_at_ab.ab>
Date: Fri, 21 Feb 2003 09:54:51 -0600
Message-ID: <fvWcnftPUoZW1sujXTWcog_at_comcast.com>
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;
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
Date: Fri, 21 Feb 2003 09:54:51 -0600
Message-ID: <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\MyDocuments\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> Received on Fri Feb 21 2003 - 16:54:51 CET