PLS00103
I enoutnered PLS00103 error for the following PL/SQL code after migration from SYBASE:
--Sybase BEGIN TRANSACTION;
utils.incrementTrancount;
WHILE v_edc_to_date <= v_to_date
LOOP
DECLARE
v_temp NUMBER(1, 0) := 0;
BEGIN
BEGIN
v_year := utils.datename('YEAR', v_edc_from_date) ;
EXCEPTION
WHEN OTHERS THEN
v_sys_error := SQLCODE;
END;
IF utils.datepart('WEEKDAY', '01Jan' || v_year) = 0 THEN
BEGIN
v_week := utils.datepart('WEEK', v_edc_from_date) ;
EXCEPTION
WHEN OTHERS THEN
v_sys_error := SQLCODE;
END;
ELSE
BEGIN
v_week := utils.datepart('WEEK', v_edc_from_date) - 1 ;
EXCEPTION
WHEN OTHERS THEN
v_sys_error := SQLCODE;