<mapper namespace="ru.pac.DataMapper">
     
    <select id="getData" parameterType="ru.data.Dto" statementType="CALLABLE">
        {#{data,jdbcType=CURSOR, typeHandler=ru.data.typeHandlers.RegisterTypeHandler, mode=OUT} = call USER.PAC.GET_DATA
        (#{id,jdbcType=BIGINT,mode=IN},
        #{firstType, jdbcType=VARCHAR, mode=IN},
        #{dataType, jdbcType=VARCHAR, mode=IN},
        #{fields, jdbcType=VARCHAR, mode=IN},
        #{filter, jdbcType=VARCHAR, mode=IN})}
    </select>
     
    </mapper>

 public class RegisterTypeHandler implements TypeHandler {
        @Override
        public void setParameter(PreparedStatement statement, int index, Object payments, JdbcType jdbcType) throws SQLException {
            
     
        }
     
        @Override
        public Object getResult(ResultSet rs, String columnName) throws SQLException {
         throw new UnsupportedOperationException();
        }
     
        @Override
        public Object getResult(ResultSet rs, int columnIndex) throws SQLException {
            throw new UnsupportedOperationException();
        }
     
        @Override
        public Object getResult(CallableStatement cs, int columnIndex) throws SQLException {
            return cs.getObject(columnIndex);
     
        }
    }