Re: Executing Server Jobs
Date: Mon, 04 Jan 1999 05:36:25 -0800
Message-ID: <3690C3D9.2507EB10_at_nettwerk.com>
Hi there-
Before going to 8.0.5, we were using 7.3.3 with a thing called the PLEX server.
Check it out at
http://govt.us.oracle.com/govt/owa/style.page?p_id=62&p_sub=3
It allowed us to interact with the OS via DBMS_PIPE calls.
You're right, though, it's anything BUT easy!
Good luck...
...jeff
Danny Hyett wrote:
>
> Thanx for the help. Unfortunately, we are using Oracle 7.3.3 which as far as
> I can tell doesn't utilise external procedures. They are a feature of
> Version 8 (according to Oracle Technology Network). Rather that writing 'C'
> programs, all we want to do is exectue SQL, PL/SQL & Unix Scripts on the
> server from a remote PC.
> I thought it was going to be a simple thing to do !
>
> nix wrote in message <368B82B5.F678C72F_at_rnix.com>...
> >The things you might look into are DBMS_PIPE, DBMS_JOB (server side
> >packages) and External Procedures (started with 7.3?).
> >It used to be done by having a OS program running waiting for messages
> >from the database on a pipe (DBMS_PIPE) but the better way now is to use
> >External Procedures.
> >
> >Danny Hyett wrote:
> >>
> >> Please help,
> >>
> >> Is there any way of executing commands on the server via a Forms 5.0
> >> session? I have a little information about a utility called DYNAPIPE, but
> as
> >> yet, I have had no success with it.
> >>
> >> I appreciate ANY advice
> >>
> >> Danny.
> >
> >--
> >--robert mailto:nix_at_rnix.com
Received on Mon Jan 04 1999 - 14:36:25 CET