ORA-01403: no data found
610392Jan 7 2008 — edited Jan 7 2008I am using utl_file to extract data from a text file. I am using the code like below.
-
-
-
loop
UTL_FILE.get_line(input_file,data);
EXIT WHEN LENGTH(data) <=0;
IF(substr(data,92,4) = '2000') THEN
Total_Invoice_Amount:=TRIM(SUBSTR(data,366,22));
utl_file.put_line (output_file,Total_Invoice_Amount);
END IF;
END LOOP;
-
-
-
at the end of file as there is no more data the line"UTL_FILE.get_line(input_file,data);" raises an exception no data found.
ORA-01403: no data found
as a result control goes to exception block & my remaining code r not geting executed.
Please help me solving this problem.