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?
I´m trying to read a file.
but always I have a problem if the directory
CREATE OR REPLACE PROCEDURE PROC_read_file (
p_directory in varchar2,
p_file_name in varchar2
line varchar2(10000) := NULL;
file_to_read := utl_file.fopen(p_directory,p_file_name, 'R');
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
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.