No Data Found
while I am trying to load data from ".csv" file to custom table. Data inserted into table but getting error message also "ORA-01403: no data found".
For Ex: In .csv file contains 14 records, all records inserted into custom table and also getting error message.
Pls check the code and let me know how to handle above mentioned error in the code.
CREATE OR REPLACE PACKAGE body xx_test
AS
PROCEDURE xx_1
(p_retbuffer OUT VARCHAR2 ,
p_retcode OUT NUMBER ,
p_file_name IN VARCHAR2)
is
l_line varchar2(1000);
l_handle utl_file.file_Type;
l_state varchar2(10);
l_city varchar2(1000);