how to determine if a file is empty in pl/sql
548623Nov 28 2006 — edited Nov 28 2006Hi, guys.
I am using pl/sql and need to find if a file is empty, I try to use utl_file.get_line (bfile_name, test_line) to read from an empty file and hope it will raise the no_data_found exception, but it doesn't work. so I use length(test_line) , but it shows length 0f test_line is 558, how come it? how to determine if a file is empty?
can any one help to solve this problem? Thanks very much!