求助 proc编译报错PCC-S-02201问题

feng54

报错信息如下：
Pro*C/C++: Release 10.2.0.1.0 - Production on Tue Feb 14 10:40:03 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

System default option values taken from: /home/db/oracle/10g/oralce10g.2.0.1/precomp/admin/pcscfg.cfg

Syntax error at line 848, column 9, file loadmx.ec:
Error at line 848, column 9 in file loadmx.ec
(select count(*) from  tap_tran_conf)
........1
PCC-S-02201, Encountered the symbol "count" when expecting one of the following:

   ( ) * + - / . @ | at, day, hour, minute, month, second, year,
The symbol "(" was substituted for "count" to continue.

这里对应到sql语句为：
EXEC SQL select
t1.branid,t3.menuid,(select count(*) from  tap_tran_conf)
from tap_sys_ctrl t1, tap_menu t3;

从报错字面信息看是语法有问题，但是该sql语句在sqlplus及PL/SQL下可以执行。
测试了一下，在程序中只要涉及到使用类似复合查询都会报这个错误。

看了一下网上类似错误码的解决方式尝试修改参数PARSE=none，问题依旧。

doni

EXEC SQL select
t1.branid,t3.menuid,t4.cnt
from tap_sys_ctrl t1, tap_menu t3,(select count(*) cnt from  tap_tran_conf) t4;

这样应该可以，PC可能不支持一些特定的SQL语法。

feng54

修改后还真是可以了
这样的问题还有其他解决方法吗
都要想这样做一下等价转换还是有点郁闷

feng54

不对 刚才看错了  还是会报错，没有人用过类似的语句吗
Error at line 850, column 18 in file loadmx.ec
        EXEC SQL select t1.branid,t3.menuid,t4.cnt
.................1
PCC-S-02201, Encountered the symbol "t1" when expecting one of the following:

   , into, from,
The symbol "," was substituted for "t1" to continue.

doni

EXEC SQL select
t1.branid,t3.menuid,t4.cnt
INTO :a, :b, :c
from tap_sys_ctrl t1, tap_menu t3,(select count(*) cnt from  tap_tran_conf) t4;

需要INTO到宿主变量

feng54

还是不对 应该不是宿主变量的问题，
Syntax error at line 852, column 18, file loadmx.ec:
Error at line 852, column 18 in file loadmx.ec
        EXEC SQL select t1.branid,t3 .menuid,t4.cnt into :a,:b,:c
.................1
PCC-S-02201, Encountered the symbol "t1" when expecting one of the following:

   , into, from,
The symbol "," was substituted for "t1" to continue.

现在使用的编译参数如下，是不是跟参数有关系：
proc DEFINE=_PROC_ MODE=ORACLE UNSAFE_NULL=YES DBMS=V8 LINES=true CODE=ansi_c parse=no RELEASE_CURSOR=yes CLOSE_ON_COMMIT=NO LINES=YES DYNAMIC=ANSI include=/home/hfsb2/plpmbatch/include/tienon_h include=/home/hfsb2/plpmbatch/include/eix_h include=/home/hfsb2/plpmbatch/include/cust_h include=/home/hfsb2/plpmbatch/include/cust_h/sc include=/home/hfsb2/plpmbatch/include/spe_h include=/home/hfsb2/plpmbatch/include/glib_h include=/home/db/oracle/10g/oralce10g.2.0.1/precomp/public include=./include loadmx.ec