IBATIS - PROCEDURE -RESULT SET - OUT PARAM

[shiva shankarp]

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.