ordinal parameter mismatch异常（高分）
我的这个 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个参数，请高手赐教
[解决办法]
把sql放在SQL里直接执行有没有问题？
[解决办法]
学习一下。。。
