为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8_20220719_x86_rh6_64_sec_8.1.2.128_pack2
【操作系统】:Centos 7.6
【CPU】:x86
【问题描述】*:
.net 驱动 最新版本 :1.1.0.16649
出错堆栈:(我认为他是去找STR2这个参数,但实际不存在,人工添加一个报错是没有,但查不出结果来,
执行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))
参数:
就是为什么去找STR2帮我分析一下
同样可能会,SRC_STR,STR1等找不到参数
管理界面是可以查出数据来的
有个奇怪现象单步慢执行是可以正确返回 的,不断点直接执行是不行的
官方有没有人,帮看一下,