Re: iBatis queryforList not working for dynamic Stored Proc

2009-12-07 Thread abdesai
calls. The simple > answer is "yes". > > See the tag with ibatis 3 or the tag with ibatis 2. > > Jeff Butler > > > On 11/2/09, abdesai wrote: >> >> Hi ppl, >> >> I am using iBatis to call a stored proc, which in turn calls 6 other >>

iBatis queryforList not working for dynamic Stored Proc

2009-11-02 Thread abdesai
Hi ppl, I am using iBatis to call a stored proc, which in turn calls 6 other stored procs, resulting in 7 resultSets. Everything was working fine earlier. Later, I changed the 2nd stored proc(SP) to take in an additional OPTIONAL variable, (declare @var int = null), and then, changed the SP to b