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


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));

  <procedure id="getState" >
         { #result,javaType=java.lang.Integer,jdbcType=NUMERIC# = call

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.

View raw message