Re: writing text files from within stored procedure

You can use external procedure call, calling from sqlplus small C function that executes passed shell command(s), this way you can copy created files over the net, I guess.
Do not know if NT has some equivalent of secure shell...

Sergei

Ed Stevens wrote in message <91lrua$97p$1_at_nnrp1.deja.com>...
>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 - 16:32:00 CST