Home » Infrastructure » Unix » Call Shell script from SQL?
icon4.gif  Call Shell script from SQL? [message #388857] Thu, 26 February 2009 06:52 Go to next message
tkiran4u
Messages: 13
Registered: December 2005
Junior Member
Can we call a unix shell script from Windows/SQL? Pls help, thanks!
Re: Call Shell script from SQL? [message #388858 is a reply to message #388857] Thu, 26 February 2009 07:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Many examples in Unix forum.

Regards
Michel
Re: Call Shell script from SQL? [message #391317 is a reply to message #388857] Wed, 11 March 2009 14:49 Go to previous messageGo to next message
Hani2002
Messages: 2
Registered: March 2009
Junior Member
Hello

i try the search but i did not find anything
Re: Call Shell script from SQL? [message #391318 is a reply to message #388857] Wed, 11 March 2009 14:52 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you
Re: Call Shell script from SQL? [message #391319 is a reply to message #388857] Wed, 11 March 2009 15:05 Go to previous messageGo to next message
Hani2002
Messages: 2
Registered: March 2009
Junior Member
Sorry

ok my problem is i have HTML page,in this there tow command

StartUp and Shutdown for service

my server is AIX server and it was down and we replase it with other one

after thathe service on this server from the web page did not work


its SQL/PL package its called Unix shell

i dont know what is the problem and there no messeges appeare

if you can help me

ps i search for the calling in SQL i did not find it

there is a table named SHELL_QUEUE the path on the (STOP and START ) there but i dont how the SQL called it

please help

Thanks
Re: Call Shell script from SQL? [message #391323 is a reply to message #391319] Wed, 11 March 2009 16:54 Go to previous message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
*Reads message five times*

What? That makes absolutely no sense whatsoever to me.

There seems to be an AIX server, some tables and some HTML files. But how and why and where they are connected, and what the actual problem is eludes me.

Here is a pretty good example on how to call an OS command from PL/SQL though. Pretty more when you just search for it.
Previous Topic: storing multiple set of data into same excel file
Next Topic: TOP Command
Goto Forum:
  


Current Time: Thu Mar 28 10:10:49 CDT 2024