Home » SQL & PL/SQL » SQL & PL/SQL » Execute or Call shell script from oracle PLSQL procedure (oracle 9i)
Execute or Call shell script from oracle PLSQL procedure [message #390789] Mon, 09 March 2009 15:39 Go to next message
prakash2007
Messages: 14
Registered: March 2007
Junior Member
hi friends,
I want to call or execute a shell script[without using java ] from oracle plsql procedure .Oracle is in remote machine .Also i want to use the values in the same plsql procedure ,which is returned by shell script . Can anyone help me with example ....Thanks in advance .... Cool
Re: Execute or Call shell script from oracle PLSQL procedure [message #390801 is a reply to message #390789] Mon, 09 March 2009 16:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.

Regards
Michel
Re: Execute or Call shell script from oracle PLSQL procedure [message #390807 is a reply to message #390801] Mon, 09 March 2009 16:36 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
using DBMS_SCHEDULER you can define an OS script to call on the Oracle server host. You'll probably need to write STDOUT from the script to a temp file and read it in using utl_file, external table or whatever to get the shell it back into PL/SQL. Using the Java solution, you can read STDOUT directly back into PL/SQL after setting dbms_java.set_output() and then reading it back using DBMS_OUTPUT.get_line


http://forums.oracle.com/forums/message.jspa?messageID=923417

http://www.orafaq.com/forum/t/130411/0/

[Updated on: Mon, 09 March 2009 16:37]

Report message to a moderator

Previous Topic: Date difference from Prior and Current rows (merged)
Next Topic: Issues in creating a trigger which fires during user modification
Goto Forum:
  


Current Time: Sun Dec 04 08:42:57 CST 2016

Total time taken to generate the page: 0.13001 seconds