Re: Help with a scripting problem

2003-10-09 Thread bulbultyagi
c:\progra~1\RESOUR~1\robocopy - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 03:04 I am trying to issue the following command in SQL*PLUS but it doesn't like the space between 'program' and 'files'. Can anyone tell me

Help with a scripting problem

2003-10-08 Thread Smith, Ron L.
Title: Message I am trying to issue the following command in SQL*PLUS but it doesn't like the space between 'program' and 'files'. Can anyone tell me how to get around this? echo select 'host c:\program files\resource kit\robocopy;' from dual; Thanks! Ron Smith

Re: Help with a scripting problem

2003-10-08 Thread Ron Rogers
Ron, It works as you requested on 8.1.7.4. Ron mª¿ªm [EMAIL PROTECTED] 10/08/03 05:34PM I am trying to issue the following command in SQL*PLUS but it doesn't like the space between 'program' and 'files'. Can anyone tell me how to get around this? echo select 'host c:\program

Re: Help with a scripting problem

2003-10-08 Thread Stephen Andert
Ron, First of all, is echo a SQL*Plis command? Secondly, I think this will do what you want: select 'host c:\program files\resource kit\robocopy' from dual; as long as what you want is to execute the robocopy program from the SQL*Plus prompt. If you want to do something else, clarify your

RE: Help with a scripting problem

2003-10-08 Thread Smith, Ron L.
Sorry, this is what I am trying to run. But again, it barfs on the 'program files' portion of the script. I have tried with and without quotes. set heading off; set feedback off; set linesize 1000;

Re: Help with a scripting problem

2003-10-08 Thread Mladen Gogala
What is echo supposed to do? The proper command should read like this: select 'host /program\ files/resource\ kit/robocopy' from dual; On Wed, 2003-10-08 at 17:34, Smith, Ron L. wrote: I am trying to issue the following command in SQL*PLUS but it doesn't like the space between 'program' and

RE: Help with a scripting problem

2003-10-08 Thread Igor Neyman
Try using double quotes: select 'host c:\program files\resource kit\robocopy f:\oracle\oradata\llbot1\archive\ e:\BACKUP\llbot1\HOT\arch /Move;' from dual; Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Smith, Ron L. Sent: Wednesday, October 08, 2003 5:05 PM To: Multiple

RE: Help with a scripting problem

2003-10-08 Thread Smith, Ron L.
Never mind. The error was related to another problem with the script. Thanks! Ron -Original Message- Sent: Wednesday, October 08, 2003 5:24 PM To: Multiple recipients of list ORACLE-L Try using double quotes: select 'host c:\program files\resource kit\robocopy

RE: Help with a scripting problem

2003-10-08 Thread Gary W. Parker
Two options: 1. Change \program files\ to \program~1\ That should execute with no problems. 2. Another tact: select 'host '||chr(34)||'c:\program files\resource kit\robocopy'||chr(34)|| ' f:\oracle\oradata\llbot1\archive\ e:\BACKUP\llbot1\HOT\arch /Move;' from dual;

Re: Help with a scripting problem

2003-10-08 Thread Paul Drake
Ron, one could include that directory in the path, then you would not have to provide the path in the command. Pd"Smith, Ron L." [EMAIL PROTECTED] wrote: I am trying to issue the following command in SQL*PLUS but it doesn't like the space between 'program' and 'files'. Can anyone tell me how