OceanBase 数据库 PL 包含 PIVOT、静态 SQL 时，执行报 -4016, Internal error 的原因和解决方法

obclient [SYS]> BEGIN
        FOR X IN (SELECT ID FROM LBORGANIZATION WHERE ORGTYPE = 6) LOOP
          INSERT INTO wcl_yxry_fgs
            (MON, YYB, WCL_HJ, WCL_BY)
            SELECT MON,
                   X.ID YYB,
                   NVL(WCZ_HJ, 0) / MBZ_HJ * 100 WCL_HJ,
                   NVL(WCZ_BY, 0) / MBZ_BY * 100 WCL_BY
              FROM (SELECT MON, ZBDM, ZBZ
                      FROM TRYZBTJ T
                     WHERE T.ZBDM IN
                           ('YXGT_MBZ_HJ', 'YXGT_WCZ_HJ', 'YXGT_WCZ_BY', 'YXGT_MBZ_BY')
                       AND MON BETWEEN 202401 AND 202407
                       AND YYB IN (SELECT ID
                                     FROM LBORGANIZATION
                                    START WITH ID = X.ID
                                   CONNECT BY PRIOR ID = FID)) T
            PIVOT(SUM(ZBZ)
               FOR ZBDM IN('YXGT_MBZ_HJ' AS MBZ_HJ,
                           'YXGT_WCZ_HJ' AS WCZ_HJ,
                           'YXGT_MBZ_BY' AS MBZ_BY,
                           'YXGT_WCZ_BY' AS WCZ_BY));
        END LOOP;
      END;
      /
ORA-00600: internal error code, arguments: -4016, Internal error
at anonymous block , line : 3, col : 5

[24-09-25 14:31:58.166392] WARN  [PL] deep_copy (ob_pl_type.cpp:1806) [593517][0][xxxxx-xxxxx-xxxxx-xxxxx] [lt=22] [dc=0] streaming cursor can not be copy(src={id:-1, is_explicit:true, for_update:false, has_hidden_rowid:false, is_streaming:true, isopen:true, fetched:true, fetched_with_row:true, rowcount:1, current_position:-1, current_row:{row:[{"NUMBER":"6"}, {"NUMBER":"1608"}], projector:[1]}, first_row:{row:null, projector:null}, last_row:{row:null, projector:null}, in_forall:false, save_exception:false, forall_rollback:false, read_uncommited:false, trans_id:{hash:0, inc:0, addr:"0.0.0.0", t:0}, bulk_rowcount:[], bulk_exceptions:[], spi_cursor:0xfff1ccb22820, cursor_flag:0, ref_count:1, is_scrollable:false, last_execute_time:1727245918166352}, ret=-4016)
[2024-09-25 14:31:58.166419] WARN  [PL] deep_copy_cursor (ob_pl_user_type.cpp:753) [593517][0][xxxxx-xxxxx-xxxxx-xxxxx] [lt=25] [dc=0] fail to exec dest_cursor->deep_copy(*src_cursor, &allocator)(ret=-4016)