Thanks.It was indeed the ordering/sequencing that was the mistake here.I
moved it from the last to the top/first and then it started working.
Thanks very much.
Regards,
Chetan
Though I've never used oraclecursor with iBatis, I'll dare to note that
from the image attached I see that parameter
Declaimer: I am new to IBatis.
I run into exact same error message when I passed a bad/misspelled
"JDBCType" for my parameter in the parameterMap. According to this link:
http://db.apache.org/ojb/docu/guides/jdbc-types.html it seems "ORACLECURSOR"
is not a valid JDBCType. You may want to double c
Though I've never used oraclecursor with iBatis, I'll dare to note that
from the image attached I see that parametermap property for the
ORALECURSOR is the last one in the map.
But it must be the first one (order parameter map properties must match
order of ?,?... ).
On Fri, Aug 21, 2009 at 8:
First thing, I'd make sure the datatypes of the actual passed arguments match
the mapped datatypes.
2nd is the function valid in the database, can you create a pl/sql block
that calls it and get a cursor back?
Hi,
I'm facing certain problems in getting my ibatis mapping to work with an
oracle st
