Re: UTL_FILE package help needed.
Date: Tue, 18 Jan 2000 11:25:19 -0000
Message-ID: <M5Yg4.40$7R.619_at_news.colt.net>
Hmmm,
UTL_FILE is the Database equivalent of TEXT_IO and will only write to the machine that your DB resides on.....TEXT_IO (I believe) is only included as part of the Developer suite and will write to the client side, unfortunately you will have to do this from a form or report.
Probably not the answer you wanted but hope it helps
Bob
Jim West <Jim_at_jameswest.com> wrote in message
news:b4ou7so91st37vmg7nseonsiuj780rkgup_at_4ax.com...
> Howdy all,
>
> Ok, here's da scoop.
>
> I'm writing a stored procedure that will be used to query a table
> and write results to a flat file for external processing.
>
> Our DB resides on a Sun Solaris node.
>
> The procedure will be executed on PCs and other Unix nodes.
>
> The file needs to be written on the client node, i.e. the PCs and
> "other Unix" nodes.
>
> Is this possible with UTL_FILE?
>
> It seems to want to write on the node where my DB lives.
>
> Any and all help is appreciated. Thanx!
>
>
Received on Tue Jan 18 2000 - 12:25:19 CET