EXEC SQL BEGIN DECLARE SECTION;
char szSql[1024*5];
int iCount;
EXEC SQL END DECLARE SECTION;
memset(szSql,0x00,sizeof(szSql));
sprintf("select count(*) from tablename");
EXEC ORACLE OPTION( HOLD_CURSOR=YES );
EXEC SQL PREPARE STMT FROM :szSql;
EXEC SQL DECLARE course_lm CURSOR FOR STMT;
EXEC SQL OPEN course_lm;
EXEC SQL FETCH course_lm INTO :iCount;
printf("表tablename里面有[%d]条数据\",iCount);
EXEC SQL CLOSE course_lm;