注册

.net 驱动 Parameter 'STR2' not found in the collection.

Rex 2023/08/10 943 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8_20220719_x86_rh6_64_sec_8.1.2.128_pack2
【操作系统】:Centos 7.6
【CPU】:x86
【问题描述】*:
.net 驱动 最新版本 :1.1.0.16649
出错堆栈:(我认为他是去找STR2这个参数,但实际不存在,人工添加一个报错是没有,但查不出结果来,

image.png
执行SQL:

WITH MONTH_DATA AS
 (SELECT BASE_MONTH, SUM(INTEREST_AMT) INTEREST_AMT
  FROM   (SELECT SUBSTR(BASE_DATE, '6', '2') BASE_MONTH, INTEREST_AMT
           FROM   TTRUST_INTEREST T
           WHERE  O_CODE = :P_O_CODE AND
                  INSTR(BASE_DATE, :P_BASE_YEAR) > 0 --取当年
           )
  GROUP  BY BASE_MONTH)

SELECT *
FROM   (SELECT YEAR_MONTH.BASE_MONTH, INTEREST.INTEREST_AMT
         FROM   (SELECT '01' AS BASE_MONTH
                  FROM   DUAL
                  UNION ALL
                  SELECT '02' AS BASE_MONTH
                  FROM   DUAL
                  UNION ALL
                  SELECT '03' AS BASE_MONTH
                  FROM   DUAL
                  UNION ALL
                  SELECT '04' AS BASE_MONTH
                  FROM   DUAL
                  UNION ALL
                  SELECT '05' AS BASE_MONTH
                  FROM   DUAL
                  UNION ALL
                  SELECT '06' AS BASE_MONTH
                  FROM   DUAL
                  UNION ALL
                  SELECT '07' AS BASE_MONTH
                  FROM   DUAL
                  UNION ALL
                  SELECT '08' AS BASE_MONTH
                  FROM   DUAL
                  UNION ALL
                  SELECT '09' AS BASE_MONTH
                  FROM   DUAL
                  UNION ALL
                  SELECT '10' AS BASE_MONTH
                  FROM   DUAL
                  UNION ALL
                  SELECT '11' AS BASE_MONTH
                  FROM   DUAL
                  UNION ALL
                  SELECT '12' AS BASE_MONTH
                  FROM   DUAL
                  UNION ALL
                  SELECT 'TOTAL' AS BASE_MONTH
                  FROM   DUAL) YEAR_MONTH
         LEFT   JOIN (SELECT T.*
                     FROM   MONTH_DATA T
                     UNION ALL
                     SELECT 'TOTAL' AS BASE_MONTH,
                            SUM(INTEREST_AMT) AS INTEREST_AMT
                     FROM   MONTH_DATA
                     
                     ) INTEREST
         ON     INTEREST.BASE_MONTH = YEAR_MONTH.BASE_MONTH)
PIVOT (SUM(INTEREST_AMT) FOR BASE_MONTH IN('01' AS PAYMENT_1,
                                      '02' AS PAYMENT_2,
                                      '03' AS PAYMENT_3,
                                      '04' AS PAYMENT_4,
                                      '05' AS PAYMENT_5,
                                      '06' AS PAYMENT_6,
                                      '07' AS PAYMENT_7,
                                      '08' AS PAYMENT_8,
                                      '09' AS PAYMENT_9,
                                      '10' AS PAYMENT_10,
                                      '11' AS PAYMENT_11,
                                      '12' AS PAYMENT_12,
                                      'TOTAL' AS PAYMENT_TOTAL))

参数:
image.png

就是为什么去找STR2帮我分析一下

同样可能会,SRC_STR,STR1等找不到参数
管理界面是可以查出数据来的
image.png
有个奇怪现象单步慢执行是可以正确返回 的,不断点直接执行是不行的

回答 0
暂无回答
扫一扫
联系客服