ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mfs <farhan.sar...@gmail.com>
Subject Calling a function with Integer param and return type an inline params
Date Sat, 24 May 2008 09:01:22 GMT

Guys,

I am trying to call an oracle function (using inline parameters) and it just
doesnt seem to work and returns null (though the same has been tested from a
standalone plsql client returns the result as expected)..

Can anyone suggest as to what the problem is in the code below, the oracle
function takes a number argument and returns a number,  

DAO class     
-----
Integer stateId = (Integer)queryForObject("getState", new Integer(1));
System.out.println(stateId);

mapping.xml
------
  <procedure id="getState" >
         { #result,javaType=java.lang.Integer,jdbcType=NUMERIC# = call
location.get_state(#stateId,javaType=java.lang.Integer,jdbcType=NUMERIC,mode=IN#)
}
  </procedure>

Thanks in advance

-- 
View this message in context: http://www.nabble.com/Calling-a-function-with-Integer-param-and-return-type-an-inline-params-tp17445906p17445906.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


Mime
View raw message