Thank you for your response
To test anonymous code block
I tried to delete a row from the table RANGE :
<update id="deleteRange" parameterType="tn.tt.nbms.dto.RangeDTO" statementType="CALLABLE"> <![CDATA[
DO $$
DECLARE
BEGIN
delete from RANGE where ID_RANGE = #{idRange};
END $$;
</update>
it throws an exception :
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='idRange', mode=IN, javaType=class java.math.BigDecimal, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: org.postgresql.util.PSQLException: L'indice de la colonne est hors limite : 1, nombre de colonnes : 0.
but if I replace
#{idRange} by a value like 3381 for example it works
so how I can set parameters ? can you help me ?