Thread: No class found for refcursor

No class found for refcursor

From
"Kuldip"
Date:
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

Re: No class found for refcursor

From
Barry Lind
Date:
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