Oracle stored procedure write a file to a network drive
Posted on 2009-04-06
I have a stored procedure in Oracle 10G. This procedure will read from a table and create a fixed width flat file by using the: UTL_File.put_line command.
The DBA set up entries in init.ora file to
Include a parameter for utl_file_dir for each directory we want to make accessible for UTL_FILE operations.
This all works in the test environment. When we went to production no file is ever created. I believe that the init.ora file is set up correctly in production. The DIFFERENCE between test and production environment is the test database is within the domain and the production database is within it's own workgroup outside the domain. Therefore, thinking that the server that the file is to be written to, does not know who Oracle is, if that makes sense, and won't allow the file to be written.
If anyone has any ideas as to a fix or workaround, that would be great!