PL/SQL (MOSC)

MOSC Banner

PLS00103

edited Mar 6, 2013 4:08PM in PL/SQL (MOSC) 7 commentsAnswered ✓
Dear Expert,

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center