Spring + iBATIS + Stored procedure output parameter

[saurabh]

I am using iBATIS to retrieve the data from database. I am calling a stored procedure which takes 3 input parameters, out of which one serves as input and ouput. I have set the mode this parameter as INOUT in my xml file. When i call the stored procedure throug my java code, it gives me error - "retrieval of output parameters failed".
Stored procedure Output Parameter does work with spring + iBATIS ?
Please help...!!!!!!

[Chris]

Have a look at these, they may help, otherwise you need to post your sqlmap xml and Java code.

http://opensource.atlassian.com/conf...d+procedure%3F

http://www.mail-archive.com/user-jav.../msg01021.html

[gtmoorthy]

Check out the link

http://www.moorthyhome.com/blog/entr...ored_procedure

[hellsing37]

I have problems with this stored procedure:
PROCEDURE cifrarDato(
cadena IN varchar2,
cadenacifrada OUT varchar2,
proceso IN char,
ncoderr OUT number,
msgerr OUT varchar2);

I don't know how i can get return values in IBATIS.

I hope someone can help me.

atte JFAA