OraFAQ Forum: SQL & PL/SQL » UTL_FILE_DIR problem

Home » SQL & PL/SQL » SQL & PL/SQL » UTL_FILE_DIR problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

UTL_FILE_DIR problem [message #187204]

Fri, 11 August 2006 05:16

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 .

Report message to a moderator

Re: UTL_FILE_DIR problem [message #187206 is a reply to message #187204]

Fri, 11 August 2006 05:24

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: UTL_FILE_DIR problem [message #187221 is a reply to message #187206]

Fri, 11 August 2006 06:22

satish@123
Messages: 15
Registered: February 2006

Junior Member

I am using oracle 10g can you please give me one example on this

Report message to a moderator

Re: UTL_FILE_DIR problem [message #187226 is a reply to message #187221]

Fri, 11 August 2006 06:53

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Previous Topic:	cursor
Next Topic:	file operations in pl/sql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 14:14:47 CST 2024