You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user-java@ibatis.apache.org by c....@ads.it on 2006/11/21 09:22:09 UTC

Re: stored function: NUMBER result, NUMBER IN parameter !

"Jeff Butler" <je...@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