pro*c 调用存储过程编译出错

Question

pro*c 调用存储过程编译出错    /* checkpoint */
    EXEC SQL BEGIN DECLARE SECTION;
            VARCHAR jobid[20];
            VARCHAR jobstepid[25];
            int processedRows;
            char processedFlg[1];    EXEC SQL END DECLARE SECTION;-------------------------------------------------------------
  EXEC SQL EXECUTE
      BEGIN
  FW_Batch_CheckReadP(:jobid,
  :jobstepid,   
  :processedRows,
  :processedFlg   
  );   
      END;   
  END-EXEC;---------------------------------------------------------------
错误信息:
PCC-S-02345, SQLCHECK=SEMANTICS must be given when embedded PL/SQL blocks are used 
Semantic error at line 73, column 14, file daemon.pc: 
EXEC SQL EXECUTE 
.............1 
PCC-S-02345, SQLCHECK=SEMANTICS must be given when embedded PL/SQL blocks are used 
Semantic error at line 82, column 14, file daemon.pc: 
EXEC SQL EXECUTE 
pcscfg.cfg文件设置
define=(WIN32_LEAN_AND_MEAN)添加
sqlcheck=semantics
也解决不了。
请问各位如何来解决这个问题。开发环境 oracle 10g
visual studio c++ 2008

Answer 1

$ORACLE_HOME/precomp/admin/pcscfg.cfg中加入以下:
ltype=short
include=($ORACLE_HOME/precomp/public)
include=$ORACLE_HOME/precomp/hdrs
include=$ORACLE_HOME/tpcc2x_2/src
include=$ORACLE_HOME/precomp/include
include=$ORACLE_HOME/oracore/include
include=$ORACLE_HOME/oracore/public
include=$ORACLE_HOME/rdbms/include
include=$ORACLE_HOME/rdbms/public
include=$ORACLE_HOME/rdbms/demo
include=$ORACLE_HOME/nlsrtl/include
include=$ORACLE_HOME/nlsrtl/public
include=$ORACLE_HOME/network_src/include
include=$ORACLE_HOME/network_src/public
include=$ORACLE_HOME/network/include
include=$ORACLE_HOME/network/public
include=$ORACLE_HOME/plsql/public
mode=oracle
def_sqlcode=true
parse=full
lines=true
userid=scott/tiger
sqlcheck=semantics
unsafe_null=yes
dbms=v8

Answer 2

已经解决。/oracle/product8.1.7/bach/precomp/admin/pcscfg.cfg 在$ORACLE_HOME/precomp/admin/pcscfg.cfg中加入以下:
ltype=short
include=($ORACLE_HOME/precomp/public)
include=$ORACLE_HOME/precomp/hdrs
include=$ORACLE_HOME/tpcc2x_2/src
include=$ORACLE_HOME/precomp/include
include=$ORACLE_HOME/oracore/include
include=$ORACLE_HOME/oracore/public
include=$ORACLE_HOME/rdbms/include
include=$ORACLE_HOME/rdbms/public
include=$ORACLE_HOME/rdbms/demo
include=$ORACLE_HOME/nlsrtl/include
include=$ORACLE_HOME/nlsrtl/public
include=$ORACLE_HOME/network_src/include
include=$ORACLE_HOME/network_src/public
include=$ORACLE_HOME/network/include
include=$ORACLE_HOME/network/public
include=$ORACLE_HOME/plsql/public
mode=oracle
def_sqlcode=true
parse=full
lines=true
userid=scott/tiger@orcl
sqlcheck=semantics
unsafe_null=yes
dbms=v8