Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: UTL_FILE Help - ORA-29280

Re: UTL_FILE Help - ORA-29280

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 04 Apr 2005 12:20:15 -0700
Message-ID: <1112642197.259132@yasure>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US