PL/SQL (MOSC)

MOSC Banner

No Data Found

edited Mar 13, 2013 9:17PM in PL/SQL (MOSC) 6 comments
Hi Team,

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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center