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