How to map function call?

[AleBu]

Hi, I have an Oracle package with function in it which returns VARCHAR
object. Package definition for that function is:
function my_func( p_param1 in varchar2 ) return varchar2;

Mapping looks like:
<update id="my_func" parameterType="mypackage.MyFuncParam"
statementType="CALLABLE">
{#{returnValue,jdbcType=VARCHAR,javaType=String,mode=OUT}
= call MY_PACKAGE.MY_FUNC(#{param1,jdbcType=VARCHAR,mode=IN})}
</update>

MyFuncParam class contains 2 properties:
String param1;
String returnValue;

But calling that method I am having an exception like:
java.lang.ClassCastException: java.lang.Integer cannot be cast to
java.lang.String

[Jeff Butler]

That's odd. Please post the stack trace so we can see where the
exception came from.

Jeff Butler

--
Sent from my mobile device