Can I pass a cursor variable to a Oracle stored procedure from the host environment ? We are using JDBC to call the stored procedures. Our environment is Unix(AIX), Oracle 8.1.7, Java and JDBC. the host environment is Java. The database server and host environment server are not the same. I need to call a stored procedure using JDBC from Java by passing a cursor. The cursor should be the input parameter. I appreciate if you can help me on this or refer to any pointers or references.

thanx..
-Bheemsen