ordinal parameter mismatch异常（高分）

[westleo]

我的这个 SQL语句报了ordinal parameter mismatch异常，有碰到过这个异常的 朋友给个解决办法，我写出SQL语句，大家看了 别晕，有更好SQL语句代替这个的也给分

select ii.seq,ii.itemId,ii.title,ii.type,ii.displayRelationalLink,ii.relationalLink,ii.counter,ii.titleColor,ii.titlePic
from
InfoItem as ii,InfoColumn as ic,InfoColumnItem as ici,InfoTemplateParaInst as itpi
where
itpi.paraName = '是否需要审批' and itpi.paraValue = '0' and itpi.templateInstSeq = ic.templateInstanceSeq and ic.seq = ici.columnSeq and ici.itemSeq = ii.seq and ii.title like ? and ii.publishTime between to_date(?,'yyyy-mm-dd') and to_date(?,'yyyy-mm-dd') and ii.lastModifier like ? and ii.publisher like ? and ii.keyword like ?
union
select ii.seq,ii.itemId,ii.title,ii.type,ii.displayRelationalLink,ii.relationalLink,ii.counter,ii.titleColor,ii.titlePic
from
InfoItem as ii,InfoColumn as ic,InfoColumnItem as ici,InfoTemplateParaInst as itpi,InfoItemAuditing as iia
where
itpi.paraName = '是否需要审批' and itpi.paraValue = '1' and itpi.templateInstSeq = ic.templateInstanceSeq and ic.seq = ici.columnSeq and ici.itemSeq = ii.seq and iia.auditingStatus = 1 and iia.itemSeq = ii.seq and ii.title like ? and ii.publishTime between to_date(?,'yyyy-mm-dd') and to_date(?,'yyyy-mm-dd') and ii.lastModifier like ? and ii.publisher like ? and ii.keyword like ?



就是两个普通的查询union了起来，用了12个参数，请高手赐教

[westleo]

是不是吃饭的时间到了，大家都去吃饭了？高手帮忙啊

[westleo]

自己顶一下

[YuLimin]

把sql放在SQL里直接执行有没有问题？

[jicken_woo]

学习一下。。。

[huxhuxx]

http://www.javaeye.com/topic/151549
看看这篇吧 这个问题也烦着我