Re: Host Command on Solaris

From: Joel Garry <joelga_at_pebble.ml.org>
Date: 15 Apr 1998 15:47:03 -0700
Message-ID: <6h3dd7$vti$1@pebble.ml.org>

In article <353503F1.4618_at_med.pitt.edu>, Joe Condle <condle_at_med.pitt.edu> wrote:
>I am trying to use the HOST command while sqlplus. I am on a
>solaris 2.5.1 system. I can do an HOST ls and HOST pwd without
>a problem, but when I do a change directory nothing happens.
>I will type HOST cd /var/opt and return. The system pauses for
>a milli sec and seems to be executing it, but when I do HOST ls
>I am still in the same directory. Any clues?
>

Yes, you are executing the command for a subprocess which goes away when it is done. There is no way around this. If you want to do several commands just do them the way you would on one line in the shell, or echo them to a command file and execute them.

sql> host cd ~; ls; cd $ORACLE_HOME/dbs; ls

Of course, you can just say HOST and you're in a subshell to do whatever commands you want.

>
>Thanks
>
>Joe Condle
>Sys Engr
>Medical ARchival Systems, Inc.
>University of Pittsburgh Medical Center
--
These opinions are my own and not necessarily those of Information Quest

jgarry@eiq.com                           http://www.informationquest.com

http://ourworld.compuserve.com/homepages/joel_garry "See your DBA?" I AM the @#%*& DBA! Received on Wed Apr 15 1998 - 17:47:03 CDT