是proc嵌入SQL,使用了递归查询:EXEC SQL SELECT SUM(NVL(SYED,'0')) into:caZED FROM LIMITINFO WHERE ZQDM = :caZQDM and JGH IN (SELECT distinct JGBH FROM BANKINST START WITH JGBH = :caJGH CONNECT BY NOCYCLE PRIOR SJJG = JGBH);报错:PCC-S-02201, Encountered the symbol "PRIOR" when expecting one of the following: = ( * < > + - / . @ ^= | != <= >= <> at, not, between, in,
is, like, day, hour, minute, month, second, year,
The symbol "*" was substituted for "PRIOR" to continue.版上有了解的吗?
is, like, day, hour, minute, month, second, year,
The symbol "*" was substituted for "PRIOR" to continue.版上有了解的吗?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货