Hi..

Thanx a lot for ur effort.... but my doubt is how can i pass a result set to java....

for ex.. i have empno from employee table.

10

20

30

select @empno=empno from employee

if @empno is a out parameter.. can it hold 10,20,30 values???