RE: How To Run Unix Applications From The Database
- From: "Powell, Mark" <mark.powell2@xxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 7 Oct 2010 13:55:42 +0000
I would think you can now do this via the dbms_scheduler which has the ability
to run OS tasks.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Andy Klock
Sent: Thursday, October 07, 2010 9:42 AM
To: srcdco@xxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxx<mailto:srcdco@xxxxxxx>> 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@xxxxxxx<mailto:Scott.Canaan@xxxxxxx>)
(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.
Other related posts:
