cursor C is
select * from temporary
where status = 'passed';
begin


for z in C
LOOP
  INSERT INTO IM_DETAIL
 (       
 INTERMEDIARY_Id,
 TITLE           ,
 SURNAME,
 FIRSTNAME,
 MIDDLENAME,
 IM_DOB,
 IM_PAN,
 IM_PAN_STATUS,
 im_GENDER,
 im_status,
 INTERMEDIARY_TYPE,
 INTERMEDIARY_CATEGORY_ID,
 IM_CLUSTER_ID,
 OM_ID,
 PATHFINDER_ID,
 PREMIA_ID,
 IM_ROPS_LOCATION,
 IM_AS_COR_EM_ID,
 IM_AS_COR_EM_IRDA_NO,
 IM_AS_AGENT_ID,
 IM_AMADEUS_ID,
 IM_CCR_NO,
 IM_LEVEL_DESC_ID
  )
VALUES
(
'XXX',
'XXX',
000,
'26/DEC/07',
Z.intermediary_id,
z.im_initial,
z.Intermediary_Last_Name,
Z.INTERMEDIARY_FIRST_NAME,
z.Intermediary_Middle_Name,
Z.IM_DOB,
Z.IM_PAN,
z.IM_Pan_Status,
z.IM_sex ,
z.IM_Status ,
Z.INTERMEDIARY_TYPE,
z.Intermediary_Category_ID,
z.IM_Cluster_ID,
z.OM_ID ,
z.PathFinder_IM_ID ,
z.Premia_IM_ID ,
z.IM_ROPS_Location,
z.IM_Asscorp_Emp_ID ,
z.IM_Asscorp_Emp_IRDA_License_No ,
z.IM_Associated_Agent_ID  ,
z.IM_Amadeus_Id ,
z.IM_CCR_No,
z.IM_Level_Description_ID
);


INSERT INTO [B]im_address[/B]
(
 im_con_NAME,
 IM_CON_TELE_ISD_NUM1,
 IM_CON_TELE_STD_NUM1,
 IM_CON_TELE_NUM1,
 IM_CON_TELE_ISD_NUM2,
 IM_CON_TELE_STD_NUM2,
 IM_CON_TELE_NUM2,
 IM_FAX_NUMBER_ISD,
 IM_FAX_NUMBER_STD,
 faxnuMBER,
 IM_CONTACT_MOBILE_NUMBER_ISD,
 MOBILENUMBER,
 IM_PRE_MAIL_ADD_LINE1,
 IM_PRE_MAIL_ADD_LINE2,
 E_MAIL1        ,
 IM_PRE_STATE,
 IM_PRE_CITY_DISTRICT,
 IM_PRE_AREA_VILLAGE,
 IM_PRE_PIN_CODE,
 IM_PRE_COUNTRY,
 IM_PERM_MAIL_ADD_LINE1,
 IM_PERM_MAIL_ADD_LINE2,
  IM_PERM_AREA_VILLAGE,
 IM_PERM_COUNTRY,
nom_CON_TELE_ISD_NUM1,
 NOM_CON_TELE_STD_NUM1,
 NOM_CON_TELE_NUM1,
 NOM_CON_TELE_ISD_NUM2,
 NOM_CON_TELE_STD_NUM2,
NOM_CON_TELE_NUM2,
 NOM_FAX_NUMBER_ISD,
 NOM_FAX_NUMBER_STD,
 NOM_FAX_NUMBER,
 NOM_CONTACT_MOBILE_NUMBER_ISD,
 NOM_CONTACT_MOBILE_NUMBER,
 NOM_MAIL_ADD_LINE1,
 NOM_MAIL_ADD_LINE2,
 NOM_STATE,
 NOM_CITY_DISTRICT,
 NOM_AREA_VILLAGE,
 NOM_PIN_CODE,
 NOM_COUNTRY,
IM_PERM_STATE,
IM_PERM_CITY_DISTRICT,
im_perm_pincode,
nom_first_name
)
values
(
z.IM_Contact_person_Name,
z.IM_Cont_Telph_ISDcode_No1,
z.IM_Cont_Telph_STDcode_No1,
z.IM_Cont_Telph_No1,
z.IM_Cont_Telph_ISDcode_No2,
z.IM_Cont_Telph_STDcode_No2,
z.IM_Cont_Telph_No2,
z.IM_Fax_No_ISDcode ,
z.IM_Fax_No_STDcode ,
z.IM_Fax_No ,
z.IM_Cont_Mob_No_ISDcode,
z.IM_Cont_Mob_No ,
z.IM_Present_MailAddrLine1  ,
z.IM_Present_MailAddrLine2 ,
z.IM_Email_Id ,
z.IM_Present_State  ,
z.IM_Present_City_Dist  ,
z.IM_Present_Area_Vil ,
z.IM_Present_PinCode  ,
z.IM_Present_Country ,
z.IM_perm_risk_MailAddrLine1  ,
z.IM_perm_risk_MailAddrLine2 ,
z.IM_perm_risk_Area_Vil  ,
z.IM_perm_risk_Country ,
z.Nom_Cont_Telph_ISDcode_No1 ,
z.Nom_Cont_Telph_STDcode_No1 ,
z.Nom_Cont_Telph_No1 ,
z.Nom_Cont_Telph_ISDcode_No2 ,
z.Nom_Cont_Telph_STDcode_No2 ,
z.Nom_Cont_Telph_No2 ,
z.Nom_Fax_No_ISDcode ,
z.Nom_Fax_No_STDcode ,
z.Nom_Fax_No ,
z.Nom_Cont_MobNo_ISDcode ,
z.Nom_Cont_MobNo ,
z.Nom_MailAddrLine1 ,
z.Nom_MailAddrLine2 ,
z.Nom_State  ,
z.Nom_City_Dist  ,
z.Nom_Area_Vil  ,
z.Nom_PinCode  ,
z.Nom_Country,
z.IM_perm_risk_State  ,
z.IM_perm_risk_City_Dist,
z.IM_perm_risk_PinCode  ,
z.Nom_First_Name
);



INSERT INTO [B]im_license_det[/B]

(
IM_Lic_ExpDate ,
IM_Lic_Type,
im_effec_date,
im_irda_no
  )
values
(
z.IM_Lic_ExpDate,
z.IM_Lic_Type,
z.IM_Lic_Eff_Date,
z.IM_IRDA_License_no
);

insert into [B]im_nom_det[/B]

(
Nom_PAN_Number ,
Nom_Pan_Status ,
Nom_Sub_ID
)
values
(
 z.NOM_PAN_NUMBER,
 z.NOM_PAN_STATUS,
 z.NOM_SUB_ID
);

insert into im_login_det
(
COUNTRYCODE,
PERSONID,
PASSWORD,
ROLEID,
EFFECTIVEDATE,
EXPIRATIONDATE         ,
PASSWORDEXPIRATIONDATE ,
STATUS                 ,
CREATIONDATE           ,
CREATERUSERID          ,
TBLREFLOGINUSERS_VER   ,
DM_LSTUPDDT            ,
 IM_CREATION_TIME ,
IM_UPDATION_TIME
)
values
(
'xxx',
'xxx',
'xxx',
'xxx',
'xxx',
100,
'26/jul/2007',
'26/jul/2017',
'26/jul/2017',
'a',
'26/jul/2007',
'abc1',
1,
'26/jul/2007',
z.IM_Creation_Time ,
z.IM_Updation_Time
);

end loop;
Exception
   WHEN NO_DATA_FOUND THEN
      dbms_output.put_line('THERE IS NO DATA IN THE TEMP2 TABLES');  
end pr_imfinalamsupload;

INSERT INTO some_table VALUES (...);

IF SQL%ROWCOUNT = 0 
THEN
   raise an exception;
END IF;

BEGIN
  INSERT INTO DEPT (deptno, dname, loc)
    SELECT deptno, dname, loc
    FROM DEPT WHERE 1 = 2;
END;