Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to submit Unix job from Oracle PL/SQL procedure?
Rich wrote:
What you want to look into is the DBMS_PIPE package. This (with some external ProC code) will take requests from the database and pipe them to the operating system. If you need more assistance I can forward you some information that I have.
Rich
MotoX wrote:
>
> Look in the Application Developers Guide. Try Alerts, Pipes and (Ora8 only)
> external procedures.
>
> MotoX
>
> fraserpl_at_aol.com wrote in message <6mapi3$pfq$1_at_nnrp1.dejanews.com>...
> >Hi,
> >
> >I'm new to Oracle but have used other server databases. My question is how
> >can I submit a host program from an Oracle procedure.
> >
> >I am using Oracle 8 with Unix (Sun Solaris 2.6). Based upon a database
> event
> >i.e. a trigger I want to be able to trigger another job on the server that
> is
> >initiated via a Unix script.
> >
> >I can't seem to find the answer to this in any of the Oracle documentaion
> but
> >I know that this type of thing can be done via Sybase for example.
> >
> >Any ideas?
> >
> >Many thanks,
> >
> >
> >-----== Posted via Deja News, The Leader in Internet Discussion ==-----
> >http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Fri Jun 19 1998 - 10:01:46 CDT