SQL - write UPDATE script to read a text/excel file

[korito]

I trying to use below two scripts to read a text/excel file and then implement a UPDATE sql command

This is to extract from filename in order to update every individual user's name. But i encounters two problems, can anyone help to solve???

1) When i run below script, the output turns out looping 1st name instead of populating the whole list in text/excel file. How to solve?

set serveroutput on;
declare
f utl_file.file_type;
s varchar2(200);
begin
f := utl_file.fopen('firedirectory','filename','R');
utl_file.get_line(f,s);
utl_file.fclose(f);
dbms_output.put_line(s);
end;
/

2) How should i use below UPDATE script to implement into above? Please advice.
UPDATE ocgen008individual
SET ind_imagepath_v = 'filename' + '.JPG'
WHERE ind_nricno_v = 'filename';
COMMIT;

[NooNoo]

Well Korito

From the looks of it you have copied this script but failed to read the accompanying explanation. The script just gets the first line of the text file... which is why your update always has the same name.

You need to put it in a loop and work out a way to terminate the loop when you reach eof. more on utl_file