动态SQL 错误 EXEC SQL EXECUTE IMMEDIATE USING

ice2000feng

int main(void)
{
EXEC SQL BEGIN DECLARE SECTION;
char szSql[1000];
char col1[100];
EXEC SQL END DECLARE SECTION;
.....
strcpy(szSql, "DELETE FROM feng_test7 WHERE col1 = 'a'");
//strcpy(col1, "d");
EXEC SQL EXECUTE IMMEDIATE :szSql;
....

}

上面程序不会报错，执行成功。
但是下面proc就会报错：
int main(void)
{
EXEC SQL BEGIN DECLARE SECTION;
char szSql[1000];
char col1[100];
EXEC SQL END DECLARE SECTION;
.....
strcpy(szSql, "DELETE FROM feng_test7 WHERE col1 = :v1");
strcpy(col1, "d");
EXEC SQL EXECUTE IMMEDIATE :szSql USING :col1;
....

}

proc include=/usr/local/oracle/precomp/public include=/usr/local/oracle/rdbms/public include=/home/icqz/incl LINES=true CODE=cpp parse=none cpp_suffix=C RELEASE_CURSOR=yes CLOSE_ON_COMMIT=NO UNSAFE_NULL=YES DBMS=V8 CPOOL=YES LINES=YES iname=test1.pc

Pro*C/C++: Release 10.2.0.1.0 - Production on Tue Nov 26 11:50:54 2013

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

System default option values taken from: /usr/local/oracle/precomp/admin/pcscfg.cfg

Syntax error at line 176, column 36, file test1.pc:
Error at line 176, column 36 in file test1.pc
        EXEC SQL EXECUTE IMMEDIATE :szSql USING :col1;
...................................1
PCC-S-02201, Encountered the symbol "USING" when expecting one of the following:

   ; ( [ . ++ -- ->

Error at line 0, column 0 in file test1.pc
PCC-F-02102, Fatal error while doing C preprocessing
make: *** [test1.o] 错误 1


难道EXEC SQL EXECUTE IMMEDIATE 不能使用USING吗？

ice2000feng

应该去掉 IMMEDIATE就可以了