OraFAQ Forum: Client Tools

Home » Other » Client Tools » HOST Command (Oracle 8i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

HOST Command [message #398466]

Thu, 16 April 2009 06:15

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

Report message to a moderator

Re: HOST Command [message #398469 is a reply to message #398466]

Thu, 16 April 2009 06:19

Michel Cadot
Messages: 68644
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

"cat" is NOT a Windows command.

Regards
Michel

Report message to a moderator

Re: HOST Command [message #398470 is a reply to message #398466]

Thu, 16 April 2009 06:20

Littlefoot
Messages: 21808
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).

Report message to a moderator

Re: HOST Command [message #398475 is a reply to message #398466]

Thu, 16 April 2009 06:42

Derek N
Messages: 80
Registered: September 2002

Member

Yes it is a Unix command.

Report message to a moderator

Re: HOST Command [message #398800 is a reply to message #398475]

Fri, 17 April 2009 11:57

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>

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 05:53:58 CDT 2024