Re: How To Run Unix Applications From The Database
- From: Andy Klock <andy@xxxxxxxxxxxxxxx>
- To: srcdco@xxxxxxx
- Date: Thu, 7 Oct 2010 09:41:36 -0400
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> 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)
>
> (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:
