DELETE FROM tableName;
in_file := client_text_io.fopen(:file_path,'r');
        loop
           V_LINE_COUNT := V_LINE_COUNT + 1;
   begin
           client_text_io.get_line(in_file,linebuf);
exception
           when no_data_found then
   IF V_LINE_COUNT = 1 THEN
           MESSAGE('empty file');
           RAISE FORM_TRIGGER_FAILURE;
    END IF;
        exit;
end;
           V_var1 := nvl(substr(linebuf,1 ,10 ),0);
           V_var2 := nvl(substr(linebuf,12 ,2 ),0);
           V_var3 := substr(linebuf,15 ,10 );
           V_var3 :=trim(V_var3);
    IF V_var3 = '' THEN
           V_var4 :='';
       else 
           V_var4 := TO_NUMBER(V_var3) ;
    end if; 
           V_var5 := substr(linebuf,26 ,70 );

    INSERT INTO tableName VALUES (V_var1,V_var2,V_var4,V_var5);

client_text_io.new_line;
<<end_loop>> 
null;
end loop;