Problem with Utl_file.fopen

Hi,

There is problem with ult_file.fopen. When I run from the server side, there is no issue with utl_file and it is working fine.
If I run the same procedure from Client machine, I am facing problem. It throws an exception Invalid_operation.

I am using Oracle 8.2 and Unix server.

Can you please let me know what change needs to be done? Is this related to permission issue.

Thanks & Regards,
Ananth P

Questions by Ananth.p

Showing Answers 1 - 3 of 3 Answers

stshekhar

  • Jun 22nd, 2008
 

the parameter set in configuration file init.oraand UTL_FILE_DIR belongs to the directory structure in oracle server machine. And the directory structure should be on same machine as oracle server. Thus fopen can run in oracle server machine not client.
Thus fopen call on client machine will give invalid_operation i.e. file could not be opened.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions