When I was but a youngling and the Force was yet to fully develop within me, I had issues calling stored procedures which returned a CLOB.

I'm pleased that those days are behind me (somewhat) and I now want to share my learnings with you.

It's really very easy and doesn't even require that you write your own custom type handler.

Just add the following to your SqlMapConfig

<typeHandler javaType="java.sql.Clob"
 callback="com.ibatis.sqlmap.engine.type.ClobTypeHandlerCallback"/>

<parameter property="r_clob" jdbcType="CLOB" javaType="java.sql.Clob" mode="OUT"/>

Remember to cast your return value when getting it back.

String c = (String) params.get("r_clob");

And viola! That's it. Go ahead and test it out.

Enjoy.