util_file in oracle 8i packages
Posted on 2006-05-18
Currently our code uses util_file in one of our packages to write contents of a record in a hard coded unix file directory, we are planning to remove the hardcoding and write to a NFS mount directory. DBA has written to us saying there is a NFS mounted drive on the unix and it is read-writable folder, but he feels that util_file cannot be used as this is not database file.
Could you guys clarify as to when util_file can be used to write in a folder, what are the requirements for this.. Currentlly we do manually transfer files everyday and wanted to eliminate this manual process.
The code uses utl_file.fopen, fetch and put_line and fclose.