OraFAQ Forum: Unix » How to call UNIX Scripts in SQL/PLSQL procedure.

Home » Infrastructure » Unix » How to call UNIX Scripts in SQL/PLSQL procedure.

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

How to call UNIX Scripts in SQL/PLSQL procedure. [message #530045]

Fri, 04 November 2011 05:26

manojbe09
Messages: 16
Registered: October 2011
Location: MUMBAI

Junior Member

Hiii,

I want to call UNIX Scripts in my SQL/PLSQL procedure.
How can i do that...??

Please help...

Regards
Manoj

Report message to a moderator

Re: How to call UNIX Scripts in SQL/PLSQL procedure. [message #530046 is a reply to message #530045]

Fri, 04 November 2011 05:36

Littlefoot
Messages: 21759
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It's been discussed previously; search for it.

Report message to a moderator

Re: How to call UNIX Scripts in SQL/PLSQL procedure. [message #530047 is a reply to message #530046]

Fri, 04 November 2011 05:53

manojbe09
Messages: 16
Registered: October 2011
Location: MUMBAI

Junior Member

hii Littlefoot,

Thanks for quick reply,

I already searched in the forum but got posts for running PLSQL procedure from Unix, But this is exactly opposite of that. and here Unix and Oracle servers are different.

Say unix server is 97.253.20.170:31543 and
Oracle server is: 97.253.32.155:31540

So how to call the script on Unix server from the procedure on Oracle server..???

Pls help..

Report message to a moderator

Re: How to call UNIX Scripts in SQL/PLSQL procedure. [message #530050 is a reply to message #530047]

Fri, 04 November 2011 06:09

Littlefoot
Messages: 21759
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Read what Thomas said in this topic and follow the link.

Then, Ask Tom discussion.

Additionally, a Oracle External Procedure to Run Host Commands blog entry.

Google for some more.

Report message to a moderator

Previous Topic:	OS Cluster check without root privilege
Next Topic:	how to access database from unix(vmware)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 23 19:58:45 CDT 2023