RE: How To Run Unix Applications From The Database

From: Powell, Mark <mark.powell2_at_hp.com>
Date: Thu, 7 Oct 2010 13:55:42 +0000
Message-ID: <7C4BF3B32B80CC44AE37D31B172415935D11655D61_at_GVW1337EXC.americas.hpqcorp.net>

I would think you can now do this via the dbms_scheduler which has the ability to run OS tasks.

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andy Klock Sent: Thursday, October 07, 2010 9:42 AM To: srcdco_at_rit.edu
Cc: oracle-l_at_freelists.org
Subject: Re: How To Run Unix Applications From The Database

Welcome to my world. I've done this with C programs. There's an outdated primer in MOS: How to Call a UNIX Shell Script From PL/SQL Using External Procedures [ID 168065.1]

And I've done this with Java stored procedures. However, the easiest to implement and control (provided you are trying to run a unix program on the database server) is through a scheduled job.

All three have security concerns that you'll need to think about. In 11g, there's an ability to call remote programs (via a client side agent) but I've never had to set that up.

On Thu, Oct 7, 2010 at 9:28 AM, Scott Canaan <srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>> wrote:

   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:55:42 CDT