Hi,
i struggling with UTL_FILE.fgetattr. Why is the following code returns: "file doesnt exist" as soon as i'm using the variable "date_convert" instead of the file name directly?
Code:
DECLARE
ex BOOLEAN;
file_length NUMBER;
blsize NUMBER;
date_convert char(250);
test char(250);
BEGIN
date_convert := 'ABC_TEST_' ||
to_char(sysdate - 1, '""YYYY-""MM-""DD".csv"');
test := 'ABC_TEST_2006-01-11.csv';
DBMS_OUTPUT.PUT_LINE(date_convert); --shows filename
DBMS_OUTPUT.PUT_LINE(test); --shows filename
utl_file.fgetattr('ETL_FOLDER1',
date_convert,
ex,
file_length,
blsize);
IF ex THEN
dbms_output.put_line('File Exists');
ELSE
dbms_output.put_line('File Does Not Exist');
END IF;
dbms_output.put_line('File Length: ' || TO_CHAR(file_length));
dbms_output.put_line('Block Size: ' || TO_CHAR(blsize));
END;
/
i did the same thing with UTL_FILE.fopen and that's working fine!
Of course a have the file in the correct folder and i did create the directory object correct. It is working, if i'm using the filename directly.
Oracle: 9.2.0.1
OS: Win XP