UTL_FILE on Application Server
ciceroanJan 13 2009 — edited Jan 15 2009I'm using UTL_FILE to create a HTML log file within a form. It works, but my issue is that I need to create the file on Application Server. So I tried to write
F UTL_FILE.FILE_TYPE;
F := UTL_FILE.FOPEN('\\IASSERVER\C$\','LOG_FILE.HTML','W');
I have the right to write from DBSERVER into \\IASSERVER\C$\, but when I run the form, I get this error
ORA-06512: at "SYS.UTL_FILE", line 475
0RA-29283: Invalid file operation
Is there a way to use it to create a file outside the DB Server? Or alternately which package may I use to create a HTML file on App. Server?