Re: Executing Server Jobs

From: Danny Hyett <Danny.H_at_telinco.co.uk>
Date: Mon, 4 Jan 1999 11:03:54 -0000
Message-ID: <76q79s$8s6$1_at_news1.cableinet.co.uk>


[Quoted] 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 - 12:03:54 CET

Original text of this message