Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!cyclone.bc.net!newsfeed2.telusplanet.net!newsfeed.telus.net!edtnps89.POSTED!3fabb59e!not-for-mail From: HansF Subject: Re: UTL_FILE Help - ORA-29280 User-Agent: Pan/0.14.2.92 ('Ere, he says he's not dead.) Message-Id: Newsgroups: comp.databases.oracle.misc References: <1112314311.467309.130340@z14g2000cwz.googlegroups.com> <_q03e.13157$ZB6.4109@newssvr19.news.prodigy.com> <1112342025.33232.0@dyke.uk.clara.net> <1112641184.468810.262300@z14g2000cwz.googlegroups.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Lines: 30 Date: Mon, 04 Apr 2005 19:26:10 GMT NNTP-Posting-Host: 64.230.44.53 X-Trace: edtnps89 1112642770 64.230.44.53 (Mon, 04 Apr 2005 13:26:10 MDT) NNTP-Posting-Date: Mon, 04 Apr 2005 13:26:10 MDT Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:117935 On Mon, 04 Apr 2005 11:59:44 -0700, Jonathon interested us by writing: > > > 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)? There are two cars. You are driving one. You now need to steer the other. Any ideas how to do that? Some ideas for your problem ... Since the database server, and it's services, can only access the database server's host machine, you need to make the application server's host disk available to the database server's host machine. (Samba, NFS?) Or change your strategy and have the write performed in the App Server. Or add a process to copy from the database server's host to the app server's host. (Perhaps UTL_TCP supplied PL/SQL package.) -- Hans Forbrich Canada-wide Oracle training and consulting mailto: Fuzzy.GreyBeard_at_gmail.com *** I no longer assist with top-posted newsgroup queries ***