Error in jdbc while executing procedure

[Eshwar Prasad]

I have written a procedure with OUT parameter as below.

 
Create or replace procedure sample(userList OUT cursorpack.refcursor)     
IS   
cursor user_cur is
select password from usertab where password=’testpass’;
userList1 user_cur%rowtype;
begin 
IF NOT user_cur%ISOPEN THEN
OPEN user_cur;
END IF;
WHILE user_cur%FOUND
Loop
dbms_output.put_line('--------'|| userList1.password);
FETCH user_cur INTO userList1;
end loop;
end;    

Although the procedure is compiled i am getting the message "Cursor closed" in my JSP page while executing. Please let me know how to use the cursor that is declared as OUT parameter in this procedure.

[Jan Cumps]

I think you have already traversed the complete cursor inside your pl/sql block, before you return the control to Java.
Have you tried any of the available tutorials on this topic first?

Regards, Jan