ibatis执行查询语句,可以在plsql中查询数据,但是在程序中查询不到，求大神帮忙

[md名字真难起]

select afa050, , afb010, afb002, afb003
from syn_fs_fb27 a
where 1 = 1
<isNotEmpty prepend=" And " property="afa050">
a.afa050= $afa050$
</isNotEmpty>
<isNotEmpty prepend=" And " property="fpzdm">
a.fpzdm = $fpzdm$
</isNotEmpty>
<isNotEmpty prepend=" And " property="afb010">
TO_CHAR(a.afb010) = $afb010$
</isNotEmpty>
and not exists (select * from V_TRANS_FB57
where afa050 = a.fdwdm
and afb010 = a.afb010
and afb002 = a.afb002
and afb003 = a.afb003
<!-- 表示该票段的票已全部用完 -->
and afb572 = '2')

[oxcow]

引用 楼主 u013051522 的回复:

select afa050, , afb010, afb002, afb003 from syn_fs_fb27 a where 1 = 1 <isNotEmpty prepend=" And " property="afa050"> a.afa050= $afa050$ </isNotEmpty> <isNotEmpty prepend=" And " property="fpzdm"> a.fpzdm = $fpzdm$ </isNotEmpty> <isNotEmpty prepend=" And " property="afb010"> TO_CHAR(a.afb010) = $afb010$ </isNotEmpty> and not exists (select * from V_TRANS_FB57 where afa050 = a.fdwdm and afb010 = a.afb010 and afb002 = a.afb002 and afb003 = a.afb003 <!-- 表示该票段的票已全部用完 --> and afb572 = '2')

select afa050, , afb010, afb002, afb003 from syn_fs_fb27 a 这个SQL多个逗号吧

[尼古拉斯-全蛋]

用的是控制台输出的sql在plsql中执行的？

[md名字真难起]

逗号是我写多了，代码里不多， syn_fs_fb27这个是dblink另一个库里的表

[md名字真难起]

在plsql里执行的sql语句就是从LOG里打印出来的，在plsql里可以查出来数据，但是程序里执行就是查不出来