Re: Writing to a file on the client

From: Walter Paoli <wpaoli_at_angelfire.com>
Date: 16 Nov 2001 02:52:39 -0800
Message-ID: <f9d92e0e.0111160252.422366cc@posting.google.com>

weberm_at_polaris.net (Ubiquitous) wrote in message news:<sNFI7.3836$997.294753_at_news1.rdc1.fl.home.com>...
> In article <eD2G7.238$oM5.33882_at_typhoon.mw.mediaone.net>,
> potterrb_at_mediaone.net wrote...
>
> >I would like to use DBMS_OUTPUT or UTL_FILE or some other package to write
> >to a file on an Oracle client machine. I have a procedure right now in the
> >database (on a Sun server) that writes to a file in a directory on the Sun
> >server. I would like to be able to write to a file on a Windows client
> >machine when the procedure is invoked from a client app written in Oracle
> >Forms 6.
>
> Is writing the file and FTPing it to the Windows machine unacceptable?

Why don't you try the TEXT_IO package? FOPEN, PUT_LINE, CLOSE functions works fine when you want to write to a file in your Oracle client machine.

Walter Paoli Received on Fri Nov 16 2001 - 04:52:39 CST