Re: How To Run Unix Applications From The Database
- From: Tim Hall <tim@xxxxxxxxxxxxxxx>
- To: Mayen.Shah@xxxxxxxxxx
- Date: Thu, 7 Oct 2010 15:23:18 +0100
Hi.
If you don't need an instant response, the I prefer the job as it is
native functionality.
If you need to wait for the action to complete and use the response
from it, then I prefer the Java approach.
http://www.oracle-base.com/articles/8i/ShellCommandsFromPLSQL.php
Just be careful about who you allow to use it as it can be *extremely
distructive* in the wrong hands. The permissions described in the
article allow someone to access any file and run pretty much any
command on the system.
Cheers
Tim...
On Thu, Oct 7, 2010 at 2:59 PM, <Mayen.Shah@xxxxxxxxxx> wrote:
> Hi Scott,
>
> I am using Oracle scheduler (job_type => 'EXECUTABLE'). It is working
> without any issue.
>
> - Mayen
>
>
>
>
>
> From: "Scott Canaan" <srcdco@xxxxxxx>
> To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
> Date: 10/07/2010 09:30 AM
> Subject: How To Run Unix Applications From The Database
> Sent by: oracle-l-bounce@xxxxxxxxxxxxx
> ________________________________
>
>
> 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.
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
