| From: | Barry Lind <blind(at)xythos(dot)com> |
|---|---|
| To: | Kuldip <kuldip(at)fsltechnologies(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: No class found for refcursor |
| Date: | 2003-01-13 18:05:51 |
| Message-ID: | 3E22FFFF.6070402@xythos.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2003-01-13 19:12:09 | JDBC MetaData getImportedKeys query |
| Previous Message | Barry Lind | 2003-01-13 18:03:12 | Re: Performance of request of type WHERE ... IN ( ... ) |