Can any one help me in using reference cursor as IN parameter to the PL/SQL procedure. This is possible in Oracle but I need to call the Procedure from JAVA. What will be Java Datatype for refcursor IN parameter and how to polpulate it. Can array assigned to this datatype variable? Yogesh