http://topic.csdn.net/u/20110523/10/5dac60ef-d987-4f67-92e1-c67e55a558e3.html这是我提问的原文地址。
今天又出现了这样的问题,我把SQL语句跟踪出来,仔细仔细仔细的看,终于发现了原因。
select "USERID","COMMENT_ID" "ATTACHMENTID","THREADID" "OWNERUSERID","COMMENT_ID" "ORIGINALTHREADID","BODY",0 "REPLYCOUNT",0 "FORWARDEDCOUNT","DATECREATED",null "POSTSOURCE",0 "COMMENTCOUNT",0 "FNUMBER",2 "Source"
From "MINIBLOGCOMMENTS"
where ("THREADID"='2' or "THREADID" in (SELECT "ATTACHMENTID" FROM "MINIBLOGATTACHMENTS" where "USERID"= '2' and "DATECREATED" between to_date('2011/4/23','yyyy-mm-dd hh24:mi:ss') and to_date('2011/5/23','yyyy-mm-dd hh24:mi:ss')))
and "AUDITINGSTATUS"=0 and "DATECREATED" between to_date('2011/4/23','yyyy-mm-dd hh24:mi:ss') and to_date('2011/5/23','yyyy-mm-dd hh24:mi:ss')
仔细看,看到了没0 "FNUMBER",2 "Source" 中间的逗号是中文的,改成,就没问题了,不过这种问题,在32位下的操作系统不会提示错误,在64位WIN7+VS2010下调试是不会通过的,会报ORA-00911错误,但是把上面的语句放到PL/SQL Developer里面执行也是不会报错的。