Hallo, I have a stored procedure in DB (running on Oracle) with one parameter - an Oracle object: create or replace type TEST1STRING as object( str VARCHAR(50) ) create or replace procedure test1(str IN OUT TEST1STRING) IS BEGIN str.str := 'justsometext'; END;
I am trying to call this procedure via iBatis 3. The following code is for the simplified case when parameter of stored Procedure is just a VARCHAR. The code is working. But I am unable to modify it so it would be using the Oracle type and a specific java type. <mapper> ... <select id="test1" statementType="CALLABLE" > {call test1(#{str,mode=INOUT,jdbcType=VARCHAR})} </select> ... <mapper> <configuration> ... <typeHandlers> <typeHandler javaType="String" jdbcType="VARCHAR" handler="MyTypeHandler"></typeHandler> </typeHandlers> ... </configuration> Any help would be much appreciated. Jiri Samek