8 Replies Latest reply: Feb 7, 2014 5:06 PM by AnnPricks E RSS

    [Error] PLS-00103 (2041: 25): PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

    2603275


      I have the below procedure and the error is marked. Please help.

       

       

      sp_refresh_tables


      IS


      NUMBER := get_run_id;


      NUMBER := NULL;


      VARCHAR2 (500) := NULL;


      BEGIN


      csxp_refresh_tabs.sp_csxt_log


      (



      ,'SP_REFRESH_TABLES started'


      ,err_i


      ,err_x


      );



      COMMIT;



      csxp_refresh_tabs.sp_refresh_brg_trk (runnum);


      csxp_refresh_tabs.sp_refresh_eng_mp_ft (runnum);


      csxp_refresh_tabs.sp_refresh_eng_oex (runnum);


      csxp_refresh_tabs.sp_refresh_eng_ref (runnum);


      csxp_refresh_tabs.sp_refresh_eng_surf (runnum);


      csxp_refresh_tabs.sp_refresh_eng_surf_det (runnum);


      csxp_refresh_tabs.sp_refresh_eng_team (runnum);


      csxp_refresh_tabs.sp_refresh_rp_trk (runnum);


      csxp_refresh_tabs.sp_refresh_bridge (runnum);


      csxp_refresh_tabs.sp_refresh_bridge_codeset (runnum);


      csxp_refresh_tabs.sp_refresh_eng_boundry (runnum);


      csxp_refresh_tabs.sp_refresh_eng_bound_desc (runnum);


      csxp_refresh_tabs.sp_refresh_eng_rail_aggregate (runnum);


      csxp_refresh_tabs.sp_refresh_eng_rail_defect2 (runnum);


      csxp_refresh_tabs.sp_refresh_eng_timber_agg (runnum);


      csxp_refresh_tabs.sp_refresh_eng_timbering (runnum);


      csxp_refresh_tabs.sp_refresh_eng_tmbrng_detail (runnum);


      csxp_refresh_tabs.sp_refresh_roadway_machine (runnum);


      csxp_refresh_tabs.sp_refresh_rdway_mach_detail (runnum);


      csxp_refresh_tabs.sp_refresh_super_structure (runnum);


      csxp_refresh_tabs.sp_refresh_ti_reference (runnum);


      csxp_refresh_tabs.sp_refresh_tmp_curr_measure (runnum);


      csxp_refresh_tabs.sp_refresh_tmp_seg_lookup (runnum);


      csxp_refresh_tabs.sp_refresh_tunnel (runnum);


      csxp_refresh_tabs.sp_refresh_curve (runnum);


      csxp_refresh_tabs.sp_refresh_incident (runnum);


      csxp_refresh_tabs.sp_refresh_rc_track_charts (runnum);


      csxp_refresh_tabs.sp_refresh_speed (runnum);


      csxp_refresh_tabs.sp_refresh_wdi_detector (runnum);


      csxp_refresh_tabs.sp_refresh_eng_lubricator(runnum);


      csxp_refresh_tabs.sp_readrecords(runnum);


      csxp_refresh_tabs.sp_readrecords1(runnum);



      csxp_refresh_tabs.sp_csxt_log


      (



      ,'SP_REFRESH_TABLES completed successfully'


      ,err_i


      ,err_x


      );



      COMMIT;


      EXCEPTION


      WHEN OTHERS


      THEN


      := SQLCODE;


      := SQLERRM;



      csxp_refresh_tabs.sp_csxt_log


      (



      ,'SP_REFRESH_TABLES execution contained an error'


      ,err_i


      ,err_x


      );


      END sp_refresh_tables;-------------------------------------error at this line