PB 调用这个数据窗口,报select error:ORA-00936:缺乏表达式

SELECT "L_HYXM"."HYID",

"L_HYXM"."HYXM",

"L_HYXM"."KSDM",

"L_HYXM"."DJ",

"L_HYXM"."SYXM",

"L_HYXM"."SL",

"L_HYXM"."YLXH",

"L_HYXM"."SRM1",

"L_HYXM"."SRM2",

"L_HYXM"."SRM3",

"L_HYXM"."INUREDATE",

"L_HYXM"."OPERATOR",

"L_HYXM"."FLAG",

"L_HYXM"."NOTE",

"L_HYXM"."DEFRESULT",

"L_HYXM"."EMERGENCY",

"L_HYXM"."SFXM",

"L_HYXM"."XMDH",

"L_HYXM"."XMXH",

"L_HYXM"."YBLX",

"L_HYXM"."BGSJ_DD",

"L_HYXM"."DJSJ_DD",

"L_HYXM"."USEDNOW",

"L_HYXM"."XMLBA",

"L_HYXM"."XMLBB",

"L_HYXM"."SJXMLB",

"L_HYXM"."JBLB",

"L_HYXM"."LCYY",

"L_HYXM"."FHLX",

"L_HYXM"."BQLX",

"L_HYXM"."GBXM",

"L_HYXM"."STBH",

"L_HYXM"."FYMC",

"L_HYXM"."ZHPB",

"L_HYXM"."HISLB",

"L_HYXM"."BBFS",

"L_HYXM"."USENOW",

"L_HYXM"."SHOW_GZ",

"L_HYXM"."SHOW_BG",

"L_HYXM"."ZHLB",

"L_HYXM"."XZKS",

"L_HYXM"."XZLB",

"L_HYXM"."QTZH",

"L_HYXM"."TQBJSJ",

"L_HYXM"."NEEDYY",

"L_HYXM"."JJRXM",

"L_HYXM"."HYXMBM",

"L_HYXM"."LCCSTYPE",

"L_HYXM"."ISCFKD",

"L_HYXM"."CSTC",

"L_HYXM"."CSSM",

"L_HYXM"."SQKD"
FROM "L_HYXM",

"L_TESTDESCRIBE"

WHERE "L_TESTDESCRIBE"."TESTID" IN (:ar_testid) AND "L_HYXM"."USENOW" = 1 AND

"L_HYXM"."YLXH" = "L_TESTDESCRIBE"."YLXH" AND
"L_HYXM"."YLXH" > 0 AND ("L_HYXM"."ZHPB" = 0 OR "L_HYXM"."ZHPB" IS NULL)

2个回答

你的列名是不是有错误

连接的oracle数据库,列名没有错误。。。。

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
立即提问