Re: File access ????

From: L. Tseng <lesliet_at_u.washington.edu>
Date: 1997/01/09
Message-ID: <5b3hnk$pvo@nntp1.u.washington.edu>#1/1

Roger,

From the Oracle book, there is an example program called daemon.pc. Is this the kind of Pro*C program you're talking about? If that's the case, should the c program constabtly run in the back ground as a daemon process?
Do you or anybody know anything about how this shold be done in NT? Thanks, -Leslie

In article <01bbfd81$a25af8a0$096fc589_at_LHV-06.labinterlink.com>, Roger Snowden <rsnowden_at_labinterlink.com> wrote:
>> Does anybody know if it is possible to create and write to a file from
>> within a Stored Procedure
>> in oracle 7.2.3.???
>
>Yes. Create a PRO*C program that opens an Oracle session. Use the DBMS
>PIPE facility to enable communcations between oracle sessions. The stored
>proc sends the info to the C program (via the session pipe), the C program
>creates the os-level disk file. Pretty simple actually.
>
>No room to fully explain pipes here, but look on the directory where all
>the SQL utilities are stored on your server. Read about it. It all works.
>
>Roger.
Received on Thu Jan 09 1997 - 00:00:00 CST