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