OraFAQ Forum: Unix » Call Shell script from SQL?

Home » Infrastructure » Unix » Call Shell script from SQL?

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

Call Shell script from SQL? [message #388857]

Thu, 26 February 2009 06:52

tkiran4u
Messages: 13
Registered: December 2005

Junior Member

Can we call a unix shell script from Windows/SQL? Pls help, thanks!

Report message to a moderator

Re: Call Shell script from SQL? [message #388858 is a reply to message #388857]

Thu, 26 February 2009 07:08

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Many examples in Unix forum.

Regards
Michel

Report message to a moderator

Re: Call Shell script from SQL? [message #391317 is a reply to message #388857]

Wed, 11 March 2009 14:49

Hani2002
Messages: 2
Registered: March 2009

Junior Member

Hello

i try the search but i did not find anything

Report message to a moderator

Re: Call Shell script from SQL? [message #391318 is a reply to message #388857]

Wed, 11 March 2009 14:52

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

Report message to a moderator

Re: Call Shell script from SQL? [message #391319 is a reply to message #388857]

Wed, 11 March 2009 15:05

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

Report message to a moderator

Re: Call Shell script from SQL? [message #391323 is a reply to message #391319]

Wed, 11 March 2009 16:54

ThomasG
Messages: 3212
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.

Report message to a moderator

Previous Topic:	storing multiple set of data into same excel file
Next Topic:	TOP Command

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 17 18:31:08 CST 2025