Re: PL/SQL write capability?
From: Robert L. Thompson <rthompson7_at_msmail2.hac.com>
Date: 1995/08/23
Message-ID: <rthompson7-2308951607450001_at_f604-1182-d23.hac.com>#1/1
> Tony Hong __ __ ____ ___ ___ ____
> thong_at_primenet.com /__)/__) / / / / /_ /\ / /_ /
> / / \ / / / / /__ / \/ /___ /
I've looked into this on my own, discussed it with Oracle Services and Oracle consultants and the only solution seems to be the use of Oracle pipes. You would send commands/data over a pipe to an application that is monitoring the pipe for data. The monitor app could read/interpret commands and process the data. Some Oracle Government folks wrote a generalized monitor application to do this called Plex, but I think it's probably just as easy to write your own. You need to look at/install the Oracle provided PL/SQL dbms_pipe package in the dbmspipe.sql file in your $ORALE_HOME/rdbms/admin directory. You may need to install other packages from this directory to install dbms_pipe. You may also other packages from this directory to be of use. Received on Wed Aug 23 1995 - 00:00:00 CEST
Date: 1995/08/23
Message-ID: <rthompson7-2308951607450001_at_f604-1182-d23.hac.com>#1/1
In article <41b097$fv_at_nnrp3.primenet.com>, thong_at_Primenet.Com (Tony Hong) wrote:
> I am relatively to Oracle & PL/SQL, so forgive me if my questions is
> trivial. (I can't find the answer in any FAQs and I don't have the
> docs.). Is it possible to open and write to a UNIX file through PL/SQL?
> What I would like to do is to create a file with formated output everytime
> a table is updated , and I was thinking of using a trigger. Also, how
> about the ability to execute a shell script from a trigger?
>
> Thanks, any help is appreciated!
>
> Tony
> --
>
> Tony Hong __ __ ____ ___ ___ ____
> thong_at_primenet.com /__)/__) / / / / /_ /\ / /_ /
> / / \ / / / / /__ / \/ /___ /
I've looked into this on my own, discussed it with Oracle Services and Oracle consultants and the only solution seems to be the use of Oracle pipes. You would send commands/data over a pipe to an application that is monitoring the pipe for data. The monitor app could read/interpret commands and process the data. Some Oracle Government folks wrote a generalized monitor application to do this called Plex, but I think it's probably just as easy to write your own. You need to look at/install the Oracle provided PL/SQL dbms_pipe package in the dbmspipe.sql file in your $ORALE_HOME/rdbms/admin directory. You may need to install other packages from this directory to install dbms_pipe. You may also other packages from this directory to be of use. Received on Wed Aug 23 1995 - 00:00:00 CEST