-
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?
-
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
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
hi,
check for the path. in UNIX its case sensitive.
if the problem still persists send accross the code.
thx
Cheers!
OraKid.
-
reading a file
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
-
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?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
-
and that the post you are replying to is 7 years old
-
Originally Posted by davey23uk
and that the post you are replying to is 7 years old
Wow! Has been a long day...
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|