Cursor as a parameter to stored procedure

From: Igor Buzatovic <igor.buzatovic_at_willevolve.com>
Date: Wed, 5 Jun 2002 19:32:42 +0200
Message-ID: <adn21k$noj$1_at_sunce.iskon.hr>


Is it possible to have a Cursor as in parameter declared in stored procedure, and then call that procedure from java . How to create new cursor in java aplication or some kind of object which can be passsed to the procedure so procedure can cast it to cursor. how to do it? I tried to make Object[][] array and then call CallableStatement's setObject(array);
The procedure expected cursor, and I got this exception: java.sql.SQLException: Invalid column type at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)

what object can I pass to procedure using callable statement if the procedure expects cursor as in parameter.

sorry for my bad english and tnx.

--
Igor Buzatovic <igor.buzatovic_at_willevolve.com>
Willevolve - software development
Received on Wed Jun 05 2002 - 19:32:42 CEST

Original text of this message