You can verify a file or directory with Exists(). Use FilePath= for a file, and Directory= for a directory: 1 SQL> call Exists(FilePath=‘{:v_my_dir}periods.csv’);