• Post Reply Bookmark Topic Watch Topic
  • New Topic

IBATIS - PROCEDURE -RESULT SET - OUT PARAM

 
shiva shankarp
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I am calling a procedure from Ibatis where the procedure will have an output parameter and a select query.

Now how can I get my select query results as well as output parameter in my java layer. My procedure looks as below.

create procedure test(count integer out)
{
select name,no from employee;
set count = select count(*) from employee;
}


Thanks
Shiva.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!