Re: UTL_FILE Help - ORA-29280

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 Received on Mon Apr 04 2005 - 13:59:44 CDT