您（最初）过帐的代码仅部分是Oracle。修复后：

update a set
  a.shiftname = 
  (select case when to_char(to_date(a.attendancedate) ,'DAY') in ('SATURDAY') and a.week in (2,4) then 'WEEKLYOFF'
               when to_char(to_date(a.attendancedate),'WW')   in ('SUNDAY') then 'WEEKLYOFF'
               else 'GENERAL1' 
          end
   from (select attendancedate,
                shiftname, 
                row_number() over (partition by to_char(to_date(attendancedate,'DAY')) order by attendancedate) as week 
         from t_attendance_attendance a1
           left join t_attendance_user_master u     on u.loginid = a1.loginid
           left join t_attendance_employee_master e on e.empid   = u.empid 
         where a1.loginid = v_loginid 
           and e.company is null
           and extract (year from attendancedate)  = extract (year from sysdate) 
           and extract (month from attendancedate) = extract (month from sysdate) 
           and nvl(shiftname,'x') = 'x'
        ) a
  );

字符串
我不知道它是否会工作或不（我没有你的表也没有数据），但-至少-它应该 * 编译 *。
类似地，对于整个过程：你应该用分号终止语句;在那个update中使用一个 proper 子查询：

CREATE OR REPLACE PACKAGE BODY pkg_attendance_dashboard
AS
   PROCEDURE proc_dashboard (v_commandtype          VARCHAR2,
                             v_loginid              VARCHAR2,
                             v_signtype             VARCHAR2,
                             v_attendancedate       DATE,
                             v_year                 VARCHAR2,
                             v_month                VARCHAR2,
                             v_ipaddress            VARCHAR2,
                             v_logonusername        VARCHAR2,
                             v_worklocation         VARCHAR2,
                             v_worklocationtype     VARCHAR2,
                             v_company              VARCHAR2,
                             v_usertype             VARCHAR2,
                             v_shiftname            VARCHAR2,
                             v_self_covid_status    VARCHAR2,
                             v_self_covid_remark    VARCHAR2,
                             v_family_covid_status  VARCHAR2,
                             v_family_covid_remark  VARCHAR2,
                             v_updatedby            VARCHAR2/*  curGetCalendar OUT SYS_REFCURSOR,
                                                            curGetCovidStatus OUT SYS_REFCURSOR,
                                                            curListCompanyName OUT SYS_REFCURSOR,
                                                            curListTowerName OUT SYS_REFCURSOR,
                                                            curAttendanceListByDate OUT SYS_REFCURSOR*/
                                                            )
   AS
      v_date  DATE := TO_DATE (v_year || '-' || v_month || '-01', 'yyyy-mm-dd');
   BEGIN
      IF v_commandtype = 'getCalendar'
      THEN
         WITH
            daysinmonth (dates)
            AS
               (SELECT v_date AS dates FROM DUAL
                UNION ALL
                SELECT INTERVAL '1' DAY (5) + dates
                  FROM daysinmonth
                 WHERE EXTRACT (MONTH FROM dates) = EXTRACT (MONTH FROM v_date))
         SELECT dates
           FROM daysinmonth;

         INSERT INTO t_attendance_attendance (loginid,
                                              attendancedate,
                                              shiftname,
                                              shiftstarttime,
                                              shiftendtime,
                                              active,
                                              attendancestatus)
            SELECT u.loginid,
                   d.dates,
                   '',
                   NULL,
                   NULL,
                   1,
                   'Approved'
              FROM daysinmonth d CROSS JOIN t_attendance_user_master u
             WHERE     EXTRACT (MONTH FROM dates) = EXTRACT (MONTH FROM v_date)
                   AND loginid = v_loginid
                   AND NOT EXISTS
                          (SELECT loginid
                             FROM t_attendance_attendance
                            WHERE     loginid = v_loginid
                                  AND EXTRACT (YEAR FROM attendancedate) =
                                      EXTRACT (YEAR FROM v_date)
                                  AND EXTRACT (MONTH FROM attendancedate) =
                                      EXTRACT (MONTH FROM v_date)
                                  AND active = 1);

         v_date := INTERVAL '1' MONTH + v_date;

         WITH
            daysinmonth (dates)
            AS
               (SELECT v_date AS dates FROM DUAL
                UNION ALL
                SELECT INTERVAL '1' DAY (5) + dates
                  FROM daysinmonth
                 WHERE EXTRACT (MONTH FROM dates) = EXTRACT (MONTH FROM v_date))
         SELECT dates
           FROM daysinmonth;

         INSERT INTO t_attendance_attendance (loginid,
                                              attendancedate,
                                              shiftname,
                                              shiftstarttime,
                                              shiftendtime,
                                              active,
                                              attendancestatus)
            SELECT u.loginid,
                   d.dates,
                   '',
                   NULL,
                   NULL,
                   1,
                   'Approved'
              FROM daysinmonth d CROSS JOIN t_attendance_user_master u
             WHERE     EXTRACT (MONTH FROM dates) = EXTRACT (MONTH FROM v_date)
                   AND loginid = v_loginid
                   AND NOT EXISTS
                          (SELECT loginid
                             FROM t_attendance_attendance
                            WHERE     loginid = v_loginid
                                  AND EXTRACT (YEAR FROM attendancedate) =
                                      EXTRACT (YEAR FROM v_date)
                                  AND EXTRACT (MONTH FROM attendancedate) =
                                      EXTRACT (MONTH FROM v_date)
                                  AND active = 1);

         OPEN curgetcalendar FOR
              SELECT attendancedate,
                     shiftname,
                     TO_CHAR (attendancedate, 'ddd') cday,
                     v_year,
                     v_month,
                     TO_CHAR (signin, 'yyyy-MM-dd hh:mm:ss tt') signin,
                     TO_CHAR (signout, 'yyyy-MM-dd hh:mm:ss tt') signout
                FROM t_attendance_attendance
               WHERE     loginid = v_loginid
                     AND EXTRACT (YEAR FROM attendancedate) = v_year
                     AND EXTRACT (MONTH FROM attendancedate) = v_month
                     AND active = 1
            ORDER BY attendancedate ASC;

         --I am getting error here in below code

         UPDATE a
            SET a.shiftname =
                   (SELECT CASE
                              WHEN     TO_CHAR (TO_DATE (a.attendancedate), 'DAY') IN
                                          ('SATURDAY')
                                   AND week IN (2, 4)
                              THEN
                                 'WEEKLYOFF'
                              WHEN TO_CHAR (TO_DATE (a.attendancedate), 'WW') IN
                                      ('SUNDAY')
                              THEN
                                 'WEEKLYOFF'
                              ELSE
                                 'GENERAL1'
                           END
                      FROM (SELECT attendancedate,
                                   shiftname,
                                   ROW_NUMBER ()
                                      OVER (
                                         PARTITION BY TO_CHAR (
                                                         TO_DATE (attendancedate, 'DAY'))
                                         ORDER BY attendancedate) AS week
                              FROM t_attendance_attendance  a1
                                   LEFT JOIN t_attendance_user_master u
                                      ON u.loginid = a1.loginid
                                   LEFT JOIN t_attendance_employee_master e
                                      ON e.empid = u.empid
                             WHERE     a1.loginid = v_loginid
                                   AND e.company = ''
                                   AND EXTRACT (YEAR FROM attendancedate) =
                                       EXTRACT (YEAR FROM SYSDATE)
                                   AND EXTRACT (MONTH FROM attendancedate) =
                                       EXTRACT (MONTH FROM SYSDATE ())
                                   AND NVL (shiftname, '') = '') a);
      END IF;
   END proc_dashboard;
END pkg_attendance_dashboard;

型