Re: UTL_FILE pkg and client side woes

It really does not make sense trying to write to the client box. Instead, create a file unique for that user and write it to the server in the specified UTL_FILE_DIR directory. You can use the user name or the unique session id, or both (to distinguish the user logged in twice). If you really need the file written to the client, write a 3GL server daemon application to write it. You can use dbms_pipe as the communications link.
- djc

Gopal <gopal_at_astro.temple.edu> wrote in article <628lgr$5it$2_at_cronkite.ocis.temple.edu>...
> In my utility I need to write stuff out to a file. I want to
> use the UTL_FILE package.
> Then I try the FOPEN file with a directory on my client box
> and NOT the server. It just does not work... it comes with
> a 'user defined error'. The program does compile and the error
> appears to be a 'runtime' error.
> I found out that there is a parameter called UTL_FILE_DIR which
> needs to be set in the initSID.ora file and that the Oracle
> instance be brought down and backup. However the directories in
> this parameter point to stuff on the Unix server.
> 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.
Received on Wed Oct 22 1997 - 00:00:00 CDT