-
-
注册真麻烦 初学数据Lv2
发表于2026-3-31 12:55
悬赏50
未解决
楼主
本帖最后由 注册真麻烦 于 2026-3-31 15:08 编辑
SQL语句执行报错，测试运行没问题，但是一做整合就报错！但是提示以下错误，无法继续往下做，AI分析没有错误。怎么办，求解答。详细如下：获取查询语句：SELECT DISTINCT
"AL8"."SPECNAME",
"AL2"."ORIGINALSTARTDATE",
"AL4"."NXPPACKAGEOUTLINENAME",
"AL2"."QTY"
FROM
"CONTAINER" "AL2",
"CURRENTSTATUS" "AL6",
"SPEC" "AL7",
"SPECBASE" "AL8",
"A_LOTATTRIBUTES" "AL3",
"A_NXPSUBPACKAGE" "AL4"
WHERE
"AL2"."CURRENTSTATUSID" = "AL6"."CURRENTSTATUSID"
AND "AL6"."SPECID" = "AL7"."SPECID"
AND "AL7"."SPECBASEID" = "AL8"."SPECBASEID"
AND "AL2"."CONTAINERID" = "AL3"."CONTAINERID"
AND "AL3"."NXPSUBPACKAGEID" = "AL4"."NXPSUBPACKAGEID"
AND "AL2"."STATUS" = 1
AND "AL2"."QTY" > 0
AND "AL8"."SPECNAME" IN ('PLATE','C_DEFLASH','E_DEFLASH','DEFLASH')
AND "AL8"."SPECNAME" NOT LIKE '%STORE';字段列表时出现异常：com.esen.jdbc.pool.impl.oracle.OraclePooledSQLException: ORA-00907: 缺失右括号
SQL语句执行报错，测试运行没问题，但是一做整合就报错！但是提示以下错误，无法继续往下做，AI分析没有错误。怎么办，求解答。详细如下：获取查询语句：SELECT DISTINCT
"AL8"."SPECNAME",
"AL2"."ORIGINALSTARTDATE",
"AL4"."NXPPACKAGEOUTLINENAME",
"AL2"."QTY"
FROM
"CONTAINER" "AL2",
"CURRENTSTATUS" "AL6",
"SPEC" "AL7",
"SPECBASE" "AL8",
"A_LOTATTRIBUTES" "AL3",
"A_NXPSUBPACKAGE" "AL4"
WHERE
"AL2"."CURRENTSTATUSID" = "AL6"."CURRENTSTATUSID"
AND "AL6"."SPECID" = "AL7"."SPECID"
AND "AL7"."SPECBASEID" = "AL8"."SPECBASEID"
AND "AL2"."CONTAINERID" = "AL3"."CONTAINERID"
AND "AL3"."NXPSUBPACKAGEID" = "AL4"."NXPSUBPACKAGEID"
AND "AL2"."STATUS" = 1
AND "AL2"."QTY" > 0
AND "AL8"."SPECNAME" IN ('PLATE','C_DEFLASH','E_DEFLASH','DEFLASH')
AND "AL8"."SPECNAME" NOT LIKE '%STORE';字段列表时出现异常：com.esen.jdbc.pool.impl.oracle.OraclePooledSQLException: ORA-00907: 缺失右括号
