Re: HOST(' ');

Joseph C Huang <jchuang+_at_andrew.cmu.edu> wrote:
>Can some guru help me with this?
>I was reading this Newsgroup and saw the usage of HOST(' '); to execute
>commands from UNIX via SQL.
>Typing in, say, HOST('ls'); works and displays the contents of the directory.
>However, typing in, say, HOST('ls -l'); , or any command with paramters,
>does not work and displays the following:
>ls -l: Command not found
>
>How do I get HOST to work with parameters?
>I'm running this on a Sparc with Solaris 2.4. Thanks.
>
>Joseph Huang
>jchuang+_at_andrew.cmu.edu
>Computing Skills Workshop
>Carnegie Mellon University

Hope this solves your problem.

SQL> host pwd
/opt/oracle/product/7.2.2/sqlplus/admin

SQL> host ls -l
-rw-r--r-- 1 oracle dba 552 Nov 22 1995 glogin.sql ...
..

SQL> host pwd;ls -l
/opt/oracle/product/7.2.2/sqlplus/admin
total 12
-rw-r--r-- 1 oracle dba 552 Nov 22 1995 glogin.sql ...
...

Naren Chintala
naren_at_mink.att.com Received on Wed Jul 31 1996 - 00:00:00 CEST