8 Replies Latest reply: Feb 7, 2014 3: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:

8dd4565c-a603-4549-8c63-9adfca1658f4 Newbie
Currently Being Moderated


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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points