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
