### Cause: java.sql.SQLSyntaxErrorException: ORA-01790: 式には対応する式と同じデータ型を持つ必要があります
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-01790: 式には対応する式と同じデータ型を持つ必要があります
] with root cause
Error : 1790, Position : 213, Sql = MERGE INTO A01_PROJECT_MEMBER t
USING (
SELECT
:1 AS PROJECT_ID,
:2 AS EMPLOYEE_ID,
:3 AS EMPLOYEE_NAME,
:4 AS ROLE,
:5 AS START_DATE,
:6 AS END_DATE,
0 AS DEL_FLG,
:7 AS INSERT_USER_ID,
:8 AS UPDATE_USER_ID
FROM dual
UNION ALL
SELECT
:9 AS PROJECT_ID,
:10 AS EMPLOYEE_ID,
:11 AS EMPLOYEE_NAME,
:12 AS ROLE,
:13 AS START_DATE,
:14 AS END_DATE,
0 AS DEL_FLG,
:15 AS INSERT_USER_ID,
:16 AS UPDATE_USER_ID
FROM dual
) s
ON (
t.PROJECT_ID = s.PROJECT_ID
AND t.EMPLOYEE_ID = s.EMPLOYEE_ID
AND t.START_DATE = s.START_DATE
)
WHEN MATCHED THEN UPDATE SET
t.EMPLOYEE_NAME = s.EMPLOYEE_NAME,
t.ROLE = s.ROLE,
t.END_DATE = CURRENT_TIMESTAMP,
t.DEL_FLG = s.DEL_FLG,
t.INSERT_USER_ID = s.INSERT_USER_ID,
t.INSERT_TIME = t.INSERT_TIME,
t.UPDATE_USER_ID = s.UPDATE_USER_ID,
t.UPDATE_TIME = CURRENT_TIMESTAMP
WHEN NOT MATCHED THEN INSERT (
PROJECT_ID, EMPLOYEE_ID, EMPLOYEE_NAME, ROLE,
START_DATE, END_DATE, DEL_FLG,
INSERT_USER_ID, INSERT_TIME, UPDATE_USER_ID, UPDATE_TIME
)
VALUES (
s.PROJECT_ID, s.EMPLOYEE_ID, s.EMPLOYEE_NAME, s.ROLE,
CURRENT_TIMESTAMP, null, s.DEL_FLG,
s.INSERT_USER_ID, CURRENT_TIMESTAMP, s.UPDATE_USER_ID, CURRENT_TIMESTAMP
), OriginalSql = MERGE INTO A01_PROJECT_MEMBER t
USING (
SELECT
? AS PROJECT_ID,
? AS EMPLOYEE_ID,
? AS EMPLOYEE_NAME,
? AS ROLE,
? AS START_DATE,
? AS END_DATE,
0 AS DEL_FLG,
? AS INSERT_USER_ID,
? AS UPDATE_USER_ID
FROM dual
UNION ALL
SELECT
? AS PROJECT_ID,
? AS EMPLOYEE_ID,
? AS EMPLOYEE_NAME,
? AS ROLE,
? AS START_DATE,
? AS END_DATE,
0 AS DEL_FLG,
? AS INSERT_USER_ID,
? AS UPDATE_USER_ID
FROM dual
) s
ON (
t.PROJECT_ID = s.PROJECT_ID
AND t.EMPLOYEE_ID = s.EMPLOYEE_ID
AND t.START_DATE = s.START_DATE
)
WHEN MATCHED THEN UPDATE SET
t.EMPLOYEE_NAME = s.EMPLOYEE_NAME,
t.ROLE = s.ROLE,
t.END_DATE = CURRENT_TIMESTAMP,
t.DEL_FLG = s.DEL_FLG,
t.INSERT_USER_ID = s.INSERT_USER_ID,
t.INSERT_TIME = t.INSERT_TIME,
t.UPDATE_USER_ID = s.UPDATE_USER_ID,
t.UPDATE_TIME = CURRENT_TIMESTAMP
WHEN NOT MATCHED THEN INSERT (
PROJECT_ID, EMPLOYEE_ID, EMPLOYEE_NAME, ROLE,
START_DATE, END_DATE, DEL_FLG,
INSERT_USER_ID, INSERT_TIME, UPDATE_USER_ID, UPDATE_TIME
)
VALUES (
s.PROJECT_ID, s.EMPLOYEE_ID, s.EMPLOYEE_NAME, s.ROLE,
CURRENT_TIMESTAMP, null, s.DEL_FLG,
s.INSERT_USER_ID, CURRENT_TIMESTAMP, s.UPDATE_USER_ID, CURRENT_TIMESTAMP
), Error Msg = ORA-01790: 式には対応する式と同じデータ型を持つ必要があります
哪个地方报错了
本文介绍了一种解决Matlab中fmincon函数出现特定错误的方法，即通过设置算法选项为'trust-region-reflective'来避免因Hessian选项设置而导致的问题。
扫一扫
1569
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
