How To Run Unix Applications From The Database

From: Scott Canaan <srcdco_at_rit.edu>
Date: Thu, 07 Oct 2010 09:28:31 -0400
Message-id: <6BDAC1AF662B0640B5D0FD885133B98008B7365C22_at_ex02mail01.ad.rit.edu>


   I need to be able to call a unix program or script from PL/SQL, particularly from a trigger. There must be a way to do this, but I can't find anything in the Oracle documentation, other than running from SQL*Plus. I can't use SQL*Plus, it has to be a stored procedure / function in the database. Is there a package that would work for this?    This needs to work for both Oracle 10g and 11g.

Thank you,

Scott Canaan '88 (Scott.Canaan_at_rit.edu<mailto:Scott.Canaan_at_rit.edu>) (585) 475-7886 - work (585) 339-8659 - cell "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer.

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 07 2010 - 08:28:31 CDT

Original text of this message