OraFAQ Forum: SQL & PL/SQL » Executing shell Script from PL/SQL block?

Home » SQL & PL/SQL » SQL & PL/SQL » Executing shell Script from PL/SQL block? (Oracle)

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

Executing shell Script from PL/SQL block? [message #349829]

Tue, 23 September 2008 04:19

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.

Report message to a moderator

Re: Executing shell Script from PL/SQL block? [message #349832 is a reply to message #349829]

Tue, 23 September 2008 04:30

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',

Report message to a moderator

Re: Executing shell Script from PL/SQL block? [message #349833 is a reply to message #349829]

Tue, 23 September 2008 04:33

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

Senior Member
Account Moderator

please read OraFAQ Forum Guide

Regards
Michel

Report message to a moderator

Re: Executing shell Script from PL/SQL block? [message #349840 is a reply to message #349832]

Tue, 23 September 2008 04:42

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.

Report message to a moderator

Previous Topic:	Bulk write in text file using utl_file
Next Topic:	to see the functions in sql *plus monitor

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 14 13:54:49 CST 2024