Home » SQL & PL/SQL » Client Tools » HOST Command (Oracle 8i)
HOST Command [message #398466] Thu, 16 April 2009 06:15 Go to next message
Derek N
Messages: 80
Registered: September 2002
Member
Hi

I am using the HOST command on a file. ie host('cat '||:global.user_home_dir||file_1||' > '||file_2);

However when running this command, the command box pops up for a split second with a message and disappears. How do i code so that the command box does not disappear as I would like to see the message?

Thanks
Re: HOST Command [message #398469 is a reply to message #398466] Thu, 16 April 2009 06:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"cat" is NOT a Windows command.

Regards
Michel
Re: HOST Command [message #398470 is a reply to message #398466] Thu, 16 April 2009 06:20 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If on MS Windows, try to add call of the CMD first; something like
host('cmd/k <your commands here>')
For more CMD switches, enter "help cmd" at the Windows command prompt.

If you are on other operating system, which one is it? If I remember well, "cat" sounds like Unix ... in that case, I wouldn't know (but perhaps the idea described above rings a bell).
Re: HOST Command [message #398475 is a reply to message #398466] Thu, 16 April 2009 06:42 Go to previous messageGo to next message
Derek N
Messages: 80
Registered: September 2002
Member
Yes it is a Unix command.
Re: HOST Command [message #398800 is a reply to message #398475] Fri, 17 April 2009 11:57 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
have you tried something like this?
SQL> host date; echo sleeping 3...; sleep 3
Fri Apr 17 09:56:43 PDT 2009
sleeping 3...

SQL> 
Previous Topic: DB Link TOAD Job error
Next Topic: ORA-01460: unimplemented or unreasonable conversion requested
Goto Forum:
  


Current Time: Fri Dec 02 22:54:04 CST 2016

Total time taken to generate the page: 0.26720 seconds