Re: UTL_FILE pkg and client side woes
Date: 1997/10/17
Message-ID: <628r7b$2ik$1_at_inet16.us.oracle.com>#1/1
In article <628lli$5it$3_at_cronkite.ocis.temple.edu>, gopal_at_astro.temple.edu (Gopal) writes:
|>
|> Hi Guys
|>
|> I am trying to write an Utility using PL/SQL .
|> Our backend is HP/Unix-Oracle 7.3 and front end in this context is
|> is SQL PLUS on Win/NT 3.51.
|>
|> In my utility I need to write stuff out to a file. I want to
|> use the UTL_FILE package.
|> In my stored proc within a package, I declare a file_handle variable
|> with the appropriate type.
[SNIP]
|>
|> Does it make sense to include the client side directories here ?.
|>
|> If not what else can I do to make UTL_FILE package write to
|> the specified client directory.
You can't. UTL_FILE can write to server-side files only. Unless you can map a client-side disk onto the server (and give Oracle write permission on it), you won't be able to use UTL_FILE for this. You may want to try spooling from SQL*Plus to create the local file, or create it on the server and then transfer to the client when it is finished.
|>
|> Regards
|> Gopal
|>
|> Please email to gopal_at_astro.ocis.temple.edu
|>
|>
|>
|>
Scott Urman Oracle Corporation surman_at_us.oracle.com
Author of _Oracle PL/SQL Programming_ ISBN 0-07-882176-2 Published by Oracle Press - http://www.osborne.com/oracle/index.htm
"The opinions expressed here are my own, and are not necessarily that of Oracle Corporation"
Received on Fri Oct 17 1997 - 00:00:00 CEST