util_file.invalid_path

N.T. 4.0, Oracle 8.1.6.

I placed parameter, 'util_file_dir = *' in init.ora

I then bounced the database.

I recompiled the procedure.
util_file.open still returns the invalid_path error.
My address syntax and address is valid.

Identical procedure worked in Oracle 8.0. Again, the file path is correct, and is located on the server that the database is located on.

What else can I do?

Quote:

---

Originally posted by DwightH
'util_file_dir = *' in init.ora

---

Is this a typo? As it repeats both in your message and in the message header, I'm suspecting it is not - so this might be the source of your problems. The parameter name is UTL_FILE_DIR, not UTIL_FILE_DIR

hi,
check for the path. in UNIX its case sensitive.

if the problem still persists send accross the code.
thx

I´m trying to read a file.
but always I have a problem if the directory

Code:

---

CREATE OR REPLACE PROCEDURE PROC_read_file (
                p_directory    in varchar2,
                p_file_name    in varchar2
                ) is

file_to_read        utl_file.file_type;
line                  varchar2(10000) := NULL;

begin
    utl_file.fclose(file_to_read);
    file_to_read := utl_file.fopen(p_directory,p_file_name, 'R');
    loop
    .
    .
    .

---

pass to the "file_to_read := utl_file.fopen(p_directory,p_file_name, 'R');"
and go to the exception - invalid_path

as the parameter p_directory in put 'C:\path' and the file 'arq1.csv' because is a excel file separate for comma

anybody may help me?
thanks for all

the directory needs to be an oracle direcotry object, not the real directory

Quote:

---

Originally Posted by davey23uk

the directory needs to be an oracle direcotry object, not the real directory

---

That's not correct, if my memory still works the way it used to do... it has to be the actual path.

NaPraia... Would you mind in posting a whole sqplus session executing the procedure and then also posting a dir showing us the directory and its content?

Maybe the parameter name in init.ora should actually be:

UTL_FILE_DIR=* :p

and not util_file_dir! :rolleyes:

Ooops, just saw that Jurij Modic already had caught it...

and that the post you are replying to is 7 years old

Quote:

---

Originally Posted by davey23uk

and that the post you are replying to is 7 years old

---

Wow! Has been a long day... :p

thanks!!
i was forgotten to see the utl_file_dir.
but now a have a new problem, i don´t have acess to this directory, and i don´t find the DBA to give me access.

see you

Quote:

---

Originally Posted by NaPraia

thanks!!
i was forgotten to see the utl_file_dir.
but now a have a new problem, i don´t have acess to this directory, and i don´t find the DBA to give me access.

see you

---

The 'oracle' OS account should have access to that directory, system admin should give access. :p