Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: UTL_FILE Help - ORA-29280
Jonathon wrote:
> Thanks for all of the help...got rid of the error. Now, I have a
> slightly different problem. I am going to be calling this stored
> procedure from forms to have it create an output file...which I need to
> eventually reside on the application server, not the database server.
> So, my question is, how do I/can I make the directory point to a folder
> on the app server (instead of the database server)?
>
> Something to the effect of CREATE DIRECTORY UTL_FILE_DIR AS as
> '<APPSERVER>/home/oracle/pdl_reports';
>
> I am have just done a brief look through the scarce documentation that
> I can find...and so far haven't seen any examples/syntax. If has any
> thoughts, suggestions, etc. then let me know. Worst case is we can
> write cron job to move the files, but hopefully we won't need that
> extra step.
>
> Again, thanks for the help,
> Jonathon
You can't unless you can make it appear visible as a drive on the data server.
SQL*Plus
SQL> HOST
$ cd <the app server>
Which I suspect you won't be able to do.
Why the App Server?
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Mon Apr 04 2005 - 14:20:15 CDT