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.
