Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01403: no data found

610392Jan 7 2008 — edited Jan 7 2008
I 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 4 2008
Added on Jan 7 2008
2 comments
1,108 views