Home » Infrastructure » Unix » How to call UNIX Scripts in SQL/PLSQL procedure.
How to call UNIX Scripts in SQL/PLSQL procedure. [message #530045] Fri, 04 November 2011 05:26 Go to next message
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
Re: How to call UNIX Scripts in SQL/PLSQL procedure. [message #530046 is a reply to message #530045] Fri, 04 November 2011 05:36 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It's been discussed previously; search for it.
Re: How to call UNIX Scripts in SQL/PLSQL procedure. [message #530047 is a reply to message #530046] Fri, 04 November 2011 05:53 Go to previous messageGo to next message
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..
Re: How to call UNIX Scripts in SQL/PLSQL procedure. [message #530050 is a reply to message #530047] Fri, 04 November 2011 06:09 Go to previous message
Littlefoot
Messages: 21806
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.
Previous Topic: OS Cluster check without root privilege
Next Topic: how to access database from unix(vmware)
Goto Forum:
  


Current Time: Thu Mar 28 12:46:19 CDT 2024