Re: Oracle iBatis documentation

2009-02-26 Thread Roger Voss
The code to make the sp call was like so: GetLineCodeLov_InOut params = new GetLineCodeLov_InOut(""); List> results = sqlMapClient.queryForList( "msol.pk_web_lov_ref_cursors.get_line_code_lov", params); Turns out the constructor for the params object sets the IN

Re: Oracle iBatis documentation

2009-02-26 Thread Bhaarat Sharma
great! thanks but just some follow up questions. so if i am calling this sp (which requires two parameters) is this the right way to call it? paramMap.put("age", age1); List returnListArray = (List) getSqlMapClientTemplate().queryForList( "mtms.pk_web_lov_ref_cursors.get_line_cod

Re: Oracle iBatis documentation

2009-02-26 Thread Roger Voss
How about this: http://ibatis.apache.org/dtd/sql-map-2.dtd";> On Thu, Feb 26, 2009 at 9:25 PM, Bhaarat Sharma wrote: > Hi, > > We have been using iBatis with sql server but now we are moving to Oracle. > Our stored procs will be changed to oracle as well. I

Oracle iBatis documentation

2009-02-26 Thread Bhaarat Sharma
Hi, We have been using iBatis with sql server but now we are moving to Oracle. Our stored procs will be changed to oracle as well. I was wondering if iBatis supports oracle stored proc cursors? because our stored procs will be returning multiple resultsets. Is there any documentation or examples