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

Question

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)

Answer 1

你的列名是不是有错误