Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UTL_FILE on Application Server

ciceroanJan 13 2009 — edited Jan 15 2009
I'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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 12 2009
Added on Jan 13 2009
13 comments
2,626 views