Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: sqlplus and spaces in path

RE: sqlplus and spaces in path

From: Ted Coyle <oracle-l_at_webthere.com>
Date: Wed, 22 Aug 2007 13:20:56 -0400
Message-ID: <003301c7e4e0$cd296d80$3921a8c0@medecision.com>


All good options, but why not move the scripts to a directory path that doesn’t include spaces, or is that too easy?

If you can schedule a task you should also be able to create a folder outside the “My Documents” directory.

Example:

    C:\scheduler\scripts  

If my years running on Windows, I’ve never run anything out of “My Documents”. Yes, it is an option, but why bother.  

Ted      


From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of JApplewhite_at_austinisd.org
Sent: Wednesday, August 22, 2007 12:19 PM To: sbootsma_at_georgebrown.ca
Cc: oracle-l_at_freelists.org; oracle-l-bounce_at_freelists.org Subject: Re: sqlplus and spaces in path  

Sam,

When I have a Scheduled Task on a Windows server, I have it execute a batch file in a certain directory. The first thing the batch file does is CD to the directory where the SQL scripts are. Then you can call them and they can call each other without worrying about the path.

Jack C. Applewhite - Database Administrator Austin I.S.D.
414.9715 (phone) / 935.5929 (pager)

Aviso del secreto: Este mensaje del email, incluyendo todos los accesorios, está para el uso único de los recipientes previstos y puede contener la información confidencial del estudiante. El uso o el acceso desautorizado se prohíbe bajo las derechas de la educación de la familia y acto federales de la aislamiento (20 U.S.C. §1232g; Parte 99 de 34 CFR). Si no eres el recipiente previsto, no puedes utilizar, no divulgas, no copias ni diseminas esta información. Entrar en contacto con por favor el remitente por el email de la contestación o por 414-9715 que entra en contacto con inmediatamente y destruir todas las copias del mensaje original, incluyendo los accesorios.

"Sam Bootsma" <sbootsma_at_georgebrown.ca> Sent by: oracle-l-bounce_at_freelists.org

08/22/2007 10:50 AM

Please respond to
sbootsma_at_georgebrown.ca

To

<oracle-l_at_freelists.org>

cc  

Subject

sqlplus and spaces in path      

Hello All,   

I am on Oracle database 10.2.0.3. My sqlplus version is 10.1.0.5.0.   

I have a sql script in a directory with embedded spaces (for example, directory C:\Documents and Settings\Staff\My Documents\_a). This sql script includes a couple of calls to other sql scripts using @@. For example:
....

@@sqlfile2
....

I can call my main sql script by enclosing the path and file name in single or double quotes. But when this sql script calls another script using @@ (eg. @@sqlfile2), sql plus returns an error like:  “SP2-0310: unable to open file "C:\Documents.sql"   

Is there any solution to this problem? Is it possible to load into sqlplus a script from a directory which has spaces in its name, and this file to call other files from the same directory with @@)?   

Thanks for any suggestions!   

Sam Bootsma
Oracle Database Administrator
Information Technology Services
George Brown College
Phone: 416-415-5000 x4933
Fax: 416-415-4836
E-mail: <mailto:sbootsma_at_georgebrown.ca> sbootsma_at_georgebrown.ca   

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 22 2007 - 12:20:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US