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>
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 developmentReceived on Wed Jun 05 2002 - 19:32:42 CEST