writing text files from within stored procedure

Subject: writing text files from within stored procedure

Platform: Oracle 8.0.5 Enterprise; NT 4 sp6

One of our developers is working on a PL/SQL procedure that, among other things, uses UTL_FILE to write to a text file. We discovered the utl_file_dir initialization parm, and everything works as expected as long as we specify a directory on the local to the box hosting the database. However, if we specify a directory on a drive that was mapped to another box, the procedure returns an INVALID OPERATION error.

My working theory is that the Oracle server is running under NT userid SYSTEM and that this userid is absolutely forbidden to touch anything across the network. (We discovered this restriction on the SYSTEM userid on a similar problem of running REXX scripts from the NT Scheduler service.

Is my working theory correct? If so, is there any good solution, or are we stuck with writing this file to a local drive, then copying to its final destination from outside the PL/SQL procedure?

TIA Ed Stevens

Sent via Deja.com
http://www.deja.com/ Received on Mon Dec 18 2000 - 14:26:59 CST