ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From c.ze...@ads.it
Subject Re: stored function: NUMBER result, NUMBER IN parameter !
Date Tue, 21 Nov 2006 08:22:09 GMT

"Jeff Butler" <jeffgbutler@gmail.com> scritti il 20/11/2006 17:24:45

> NUMBER is not a valid JDBC Type (it is Oracle specific).  See here
> for the valid options:

ohps
:/
Right.

[...]
The corrected SQL map


      <procedure id="esisteTipoRiga" parameterClass="java.util.Map">
        {#result,mode=OUT,javaType=java.lang.Integer,jdbcType=NUMERIC# =
call tipo_dato_riga.exists_id( #pId,javaType=java.lang.Integer,jdbcType=
NUMERIC,mode=IN# ) }
      </procedure>

works fine!
Thanks Jeff.

ciao
Mime
View raw message