Home » SQL & PL/SQL » SQL & PL/SQL » Invoking unix shell script from PL/SQL (merged)
Invoking unix shell script from PL/SQL (merged) [message #362616] Wed, 03 December 2008 04:42 Go to next message
kishu_meda
Messages: 3
Registered: December 2008
Location: Bangalore
Junior Member
Hi All,
i have a requirement to invoke a shell script from Pl/Sql procedure and
further to proceed based on value returned by shell script.

I know scheduling a script run from oracle scheduler, but
i am not finding the way to invoke a script from PL/Sql Procedure.

Could someone help me on the same.

Thanks,
Kis.
Re: Invoking unix shell script from PL/SQL [message #362619 is a reply to message #362616] Wed, 03 December 2008 05:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you search if this has never been asked?

Don't multipost your questions.

Regards
Michel
Re: Invoking unix shell script from PL/SQL [message #362759 is a reply to message #362619] Thu, 04 December 2008 01:32 Go to previous messageGo to next message
kishu_meda
Messages: 3
Registered: December 2008
Location: Bangalore
Junior Member
Hi Michel,
Sorry for multi posting, it happened by mistake.

Ya, i have searched but i didn't find similar queries like this.

Thanks,
Kishore.
Re: Invoking unix shell script from PL/SQL [message #362761 is a reply to message #362759] Thu, 04 December 2008 01:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Here's a starting point: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:952229840241

Regards
Michel
Re: Invoking unix shell script from PL/SQL [message #362796 is a reply to message #362761] Thu, 04 December 2008 02:57 Go to previous message
kishu_meda
Messages: 3
Registered: December 2008
Location: Bangalore
Junior Member
Michel,
Thanks for your reply.
Hope this helps me.

Thanks,
Kishore.
Previous Topic: Logic to apportion given value among 2 dates
Next Topic: Advance Constraints.
Goto Forum:
  


Current Time: Thu Dec 08 20:11:43 CST 2016

Total time taken to generate the page: 0.10492 seconds