Обсуждение: No class found for refcursor

Поиск
Список
Период
Сортировка

No class found for refcursor

От
"Kuldip"
Дата:
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

От
Barry Lind
Дата:
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