Re: running applications in unix from inside oracle.

From: Srini Manickam <sriniman_at_ix.netcom.com>
Date: Tue, 29 Sep 1998 20:51:32 -0400
Message-ID: <36118094.D7B238D0@ix.netcom.com>

If your are using oracle 7 then you can have a unix deamon process which will read the dbms_pipe and execute the command it gets from the stored proc etc. Although you could write this yourself, if you want to use it for a broader range then check out the following site for PLEX. This one has good documentation, available in MS word.

1> http://www-govt.us.oracle.com/

2> downloadable utilities.
3> downloadable utilitites.
4> Read the Lic Agreement and if you accept it go the step5
5> Plex

If you are using Oracle 8, you can configure your listener.ora and tnsnames.ora with the specified parameters. Create a Shared library which executes your application. Add the shared library as library object in oracle. Then you can use this library call to do what you want to do. This documented well in the Oracle docs.

zdenka wrote:

> dbms_pipe & dbms_jobs oracle packages
>
> james mccarthy <mccarthy_at_bayshoreleasing.com> wrote in article
> <360AAF6F.CFD5D177_at_bayshoreleasing.com>...
> > i am looking to run an application in unix and i want it triggered by
> > oracle.
> > can it be done and how.
> >
> >
Received on Tue Sep 29 1998 - 19:51:32 CDT