I´m trying to read a file.
but always I have a problem if the directory
pass to the "file_to_read := utl_file.fopen(p_directory,p_file_name, 'R');"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 . . .
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




Reply With Quote