Re: UTL_FILE problem

From: Walter T Rejuney <BlueSax_at_Unforgetable.com>
Date: Wed, 29 Nov 2000 12:36:49 -0500
Message-ID: <3A253EB1.B220394D@Unforgetable.com>

suisum_at_ecn.ab.ca wrote:

> The UTL_FILE can only write a flat file in the database server. However
> this is not suitable for 3 tier architecture if the database server is
> UNIX and the middle tier is NT.
>
> Have anyone try to use UTL_FILE to write a flat file to other platform? Or
> which tools I can use to produce a flat file?

Fairly simple. Allow a directory on the NT server to be a shared drive and then mount it as a network drive on the NT platform. Then just use that directory as you would any other directory. You might have to fiddle with the utl_file calls a bit to have the end-of-line functions come out right, but that shouldn't be any big deal - you are encapsulating your actual calls to the utl_file functions aren't you? Received on Wed Nov 29 2000 - 11:36:49 CST