Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: File access ????
> 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 Wed Jan 08 1997 - 00:00:00 CST