Re: PL/SQL write capability?

sahmad_at_mfa.com (Saad Ahmad) writes:
>Tony Hong (thong_at_Primenet.Com) 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?
 

>I don't think u would be able to do this directly.
 

>Use the dbms_pipe package and write a detached process in a 3rd
>GL which would listen on the pipe and do an action.
>If you want to maintain a log, you would send a message over the
>pipe and the program on the other end would maintain the file.

You will be able to do file i/o directly from PL/SQL in Oracle release 7.3. Received on Mon Aug 21 1995 - 00:00:00 CEST