How to submit Unix job from Oracle PL/SQL procedure?

From: <fraserpl_at_aol.com>
Date: Thu, 18 Jun 1998 10:18:44 GMT
Message-ID: <6mapi3$pfq$1@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 Thu Jun 18 1998 - 05:18:44 CDT