Home » SQL & PL/SQL » SQL & PL/SQL » Executing shell Script from PL/SQL block? (Oracle)
Executing shell Script from PL/SQL block? [message #349829] Tue, 23 September 2008 04:19 Go to next message
ksailesh
Messages: 7
Registered: August 2008
Location: India
Junior Member

Can any one please tell me how to execute the shell script from procedure soon?

Atleast give me some hint please, its very urgent.

Please let me know if u need some more info.
Re: Executing shell Script from PL/SQL block? [message #349832 is a reply to message #349829] Tue, 23 September 2008 04:30 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member

One way pf calling shell script from Oracle is,
Step 1: Create a shell script and grant execute priv to oracle
/tmp/test.sh
Step 2: Create the job with DBMS_SCHEDULER.CREATE_JOB and call the shell script.
job_action => '/tmp/test.sh',

Re: Executing shell Script from PL/SQL block? [message #349833 is a reply to message #349829] Tue, 23 September 2008 04:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
please read OraFAQ Forum Guide

Regards
Michel
Re: Executing shell Script from PL/SQL block? [message #349840 is a reply to message #349832] Tue, 23 September 2008 04:42 Go to previous message
ksailesh
Messages: 7
Registered: August 2008
Location: India
Junior Member

Thanks for quick responce.


If i need to run only once(or when ever required i need to run this procedure), what will the vale for parameter repeat_interval in DBMS_SCHEDULER.create_job.
Previous Topic: Bulk write in text file using utl_file
Next Topic: to see the functions in sql *plus monitor
Goto Forum:
  


Current Time: Fri Dec 09 13:59:22 CST 2016

Total time taken to generate the page: 0.12016 seconds