Home » SQL & PL/SQL » SQL & PL/SQL » UTL_FILE_DIR problem
UTL_FILE_DIR problem [message #187204] Fri, 11 August 2006 05:16 Go to next message
satish@123
Messages: 15
Registered: February 2006
Junior Member
hi,

I have one server machine and some client machines .I am maintaining the server machine as oracle server.In that server i declared utl_file_dir in init_newdb file . I am writing pl/sql file in client machine to read the file from local machine . I tried on that it is showing the error as

can't open file. can you please suggest me solution on this .


Re: UTL_FILE_DIR problem [message #187206 is a reply to message #187204] Fri, 11 August 2006 05:24 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>i declared utl_file_dir
for oracle 9i and above, you must be using CREATE diretory. NOT UTL_FILE.
Search the board/google for more information.
Re: UTL_FILE_DIR problem [message #187221 is a reply to message #187206] Fri, 11 August 2006 06:22 Go to previous messageGo to next message
satish@123
Messages: 15
Registered: February 2006
Junior Member
I am using oracle 10g can you please give me one example on this
Re: UTL_FILE_DIR problem [message #187226 is a reply to message #187221] Fri, 11 August 2006 06:53 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-east.oracle.com/docs/cd/B19306_01/appdev.102/b14258/u_file.htm#sthref14093
Previous Topic: cursor
Next Topic: file operations in pl/sql
Goto Forum:
  


Current Time: Thu Dec 08 16:28:13 CST 2016

Total time taken to generate the page: 0.05064 seconds