Re: UTL_FILE Package

Walter Zimmer wrote:
>
> Hi !
>
> I just discovered in the Oracle Forms Object Navigator the specification for
> the UTL_FILE package. Writing to a file is just what I need so I wrote a
> small PL/SQP Prcedure:
>
> PROCEDURE file_test IS
> file utl_file.FILE_TYPE;
> BEGIN
> file := utl_file.fopen('/home/blah, 'test.txt', 'w');
> utl_file.put(file, 'Yeah !');
> utl_file.fflush(file);
> utl_file.fclose(file);
> EXCEPTION
> -- exception handling...
> END;
>
> All I get is an exception 'invalid path' from the fopen. I tried hundreds
> of ways specifying file names and paths, but no success.
>
> Anyone knows how to use this Package ?????
> BTW: Is the file written from the server or clinet where sqlplus is running
> on ?
>
> Thanks,
> Walter
>
> walter.zimmer_at_rz.uni-ulm.de
Hai !
To my knowledge this package will give problem in client server environment ... at the same time u have to add following entry in the init.ora ...

                util_file_dir string
for eg:

                util_file_dir=c:\walter c:\rao
Then util_file package will search for these two subdirectories ... I think I read in one of the o'railley's book that ... util_file package has got some problem in client server environment ...

Have a nice time

Rao Received on Thu Jul 25 1996 - 00:00:00 CEST