Thread: No class found for refcursor
Hello friends
i am calling a function( returning refcursor )in sql select statement but when i get this from resultset using getObject following errors occurs
No class found for refcursor
please let me know how to register the classes for refcursor.
can i download the documentation of extended JDBC APIs
thanks
kuldip
kuldip
This has been discussed before on this list, please check the archives. But the short answer is for current code, you need to use getString() to get the refcursor name, and then issue a FETCH SQL statement to fetch the rows from the named refcursor into a result set. The getObject() method should work in 7.4. --Barry Kuldip wrote: > Hello friends > > i am calling a function( returning refcursor )in sql select statement > but when i get this from resultset using getObject following errors occurs > > No class found for refcursor > > please let me know how to register the classes for refcursor. > > can i download the documentation of extended JDBC APIs > > thanks > kuldip