大家好。
请问在Proc中静态SQL不支持‘IN’关键字吗?EXEC SQL DECLARE Inqmeriedc CURSOR for
SELECT MID_EDC,MERCHANT_NAME_CH_A,MERCHANT_NAME_EN,MERCHANT_ADDR,CON_TEL,OWNER_LEGWORK_ID
FROM tb_merchant_info_base
WHERE IN_DATE like :inqdt and OWNER_LEGWORK_ID in :inqstr
GROUP BY OWNER_LEGWORK_ID,MID_EDC,MERCHANT_NAME_CH_A,MERCHANT_NAME_EN,MERCHANT_ADDR,CON_TEL;报错如下:
======================================================================
[opt@BOCI src]$ make TransMain
proc iname=StatisticsModule.pc oname=StatisticsModule.c parse=nonePro*C/C++: Release 9.2.0.4.0 - Production on Thu Apr 30 13:16:57 2009Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.System default option values taken from: /home/oracle/ora9/precomp/admin/pcscfg.cfgSyntax error at line 154, column 53, file StatisticsModule.pc:
Error at line 154, column 53 in file StatisticsModule.pc
WHERE IN_DATE like :inqdt and OWNER_LEGWORK_ID in :inqstr
....................................................1
PCC-S-02201, Encountered the symbol ":" when expecting one of the following: ( multiset, the,Syntax error at line 155, column 28, file StatisticsModule.pc:
Error at line 155, column 28 in file StatisticsModule.pc
GROUP BY OWNER_LEGWORK_ID,MID_EDC,MERCHANT_NAME_CH_A,MERCHANT_NA
ME_EN,MERCHANT_ADDR,CON_TEL;
...........................1
PCC-S-02201, Encountered the symbol "," when expecting one of the following: : ) [ ] / . an identifier, a numeric constant,Error at line 0, column 0 in file StatisticsModule.pc
PCC-F-02102, Fatal error while doing C preprocessing
make: *** [StatisticsModule.o] Error 1
====================================================================================如果把‘in’改成‘like’就是正常的
请问这是哪里出了问题?谢谢!
请问在Proc中静态SQL不支持‘IN’关键字吗?EXEC SQL DECLARE Inqmeriedc CURSOR for
SELECT MID_EDC,MERCHANT_NAME_CH_A,MERCHANT_NAME_EN,MERCHANT_ADDR,CON_TEL,OWNER_LEGWORK_ID
FROM tb_merchant_info_base
WHERE IN_DATE like :inqdt and OWNER_LEGWORK_ID in :inqstr
GROUP BY OWNER_LEGWORK_ID,MID_EDC,MERCHANT_NAME_CH_A,MERCHANT_NAME_EN,MERCHANT_ADDR,CON_TEL;报错如下:
======================================================================
[opt@BOCI src]$ make TransMain
proc iname=StatisticsModule.pc oname=StatisticsModule.c parse=nonePro*C/C++: Release 9.2.0.4.0 - Production on Thu Apr 30 13:16:57 2009Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.System default option values taken from: /home/oracle/ora9/precomp/admin/pcscfg.cfgSyntax error at line 154, column 53, file StatisticsModule.pc:
Error at line 154, column 53 in file StatisticsModule.pc
WHERE IN_DATE like :inqdt and OWNER_LEGWORK_ID in :inqstr
....................................................1
PCC-S-02201, Encountered the symbol ":" when expecting one of the following: ( multiset, the,Syntax error at line 155, column 28, file StatisticsModule.pc:
Error at line 155, column 28 in file StatisticsModule.pc
GROUP BY OWNER_LEGWORK_ID,MID_EDC,MERCHANT_NAME_CH_A,MERCHANT_NA
ME_EN,MERCHANT_ADDR,CON_TEL;
...........................1
PCC-S-02201, Encountered the symbol "," when expecting one of the following: : ) [ ] / . an identifier, a numeric constant,Error at line 0, column 0 in file StatisticsModule.pc
PCC-F-02102, Fatal error while doing C preprocessing
make: *** [StatisticsModule.o] Error 1
====================================================================================如果把‘in’改成‘like’就是正常的
请问这是哪里出了问题?谢谢!
解决方案 »
- 如何实现在Oracle插入一条记录返回主键
- 两段近似的SQL,执行情况却不大相同?
- oracle批量TXT导入求救!
- 表数据被误删,坐求恢复方案,可付RMB
- sql plus 中执行存储过程的问题
- 基于ORACLE实现网页的信息抓取
- Oracle联机日志REDO01.LOG不匹配,无法启动数据库问题?
- 请教用户dsn,文件dsn,系统dsn三者的区别使用场合
- 有没有人用SQL Navigator 4的能不能提供一个注册吗?谢谢了!!
- EXECUTE IMMEDIATE 会自动提交吗
- 问下, odbc oracle ,存储过程怎么执行???调什么函数~~~~~~~~
- 关于inputtime between ... and ... 取上个月的一周的数据问题(急)
inqstr中的内容是“(1,2,3)”
需要将括号放到外面吗?