2 Replies Latest reply on Aug 27, 2015 6:00 AM by Gaz in Oz

    sqlcl - host cmd

    rpande-JavaNet

      The host command in sqlcl does not work..

       

      It just comes back without any  output

       

      version - SQLcl: Release 4.1.0 Release Candidate on Wed Aug 26 11:57:06 2015

       

      SQL> host ls -al

       

      SQL>

        • 1. Re: sqlcl - host cmd
          thatJeffSmith-Oracle

          Works for me? This is the version that ships with 4.1.1.19

           

          I'm on OS X

           

          sqlcl_host.png

          • 2. Re: sqlcl - host cmd
            Gaz in Oz

            works for me

             

            i'm on windows 7...

            C:\Oracle\sqlcl\bin>sql /NOLOG
            
            SQLcl: Release 4.1.0 Release Candidate on Thu Aug 27 15:49:01 2015
            
            Copyright (c) 1982, 2015, Oracle.  All rights reserved.
            
            
            SQL> host dir/s/b *.exe
            
            C:\Oracle\sqlcl\bin\sql.exe
            
            SQL> $dir/s/b *.exe
            
            C:\Oracle\sqlcl\bin\sql.exe
            
            SQL> !dir/s/b *.exe
            C:\Oracle\sqlcl\bin\sql.exe
            
            SQL>
            
            

            could be that your env isn't set up correctly? are you pointing at correct jdk version? have you tried "/usr/local/bin/ls -al"

            Try

            SQL> host /usr/local/bin/ls -al

            if that works then its a path issue spawning the subshell for within sqlcl... set and export PATH perhaps before calling sqlcl?... all depends on how sqlcl is being started as to whether it inherits env variables... and ofcourse your OS, we know it is a UNIX derivitive of some sort... but which?

             

            Cheers,

             

            Gaz.