| From: | Stuart Robinson <stuart(at)zapata(dot)org> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | not able to fetch from refcursor |
| Date: | 2002-07-02 08:38:26 |
| Message-ID: | Pine.LNX.4.44.0207020132220.26006-100000@www.dreamingamerica.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
I've run into another roadblock while attempting to use a function that
returns a refcursor.
Here's what happens when I run a function that returns a refcursor for a
query that I've already tested and know for sure returns one row:
mayanlanguages=#
select get_examples_by_entry_id(2879);
get_examples_by_entry_id
--------------------------
<unnamed cursor 1>
(1 row)
mayanlanguages=# FETCH ALL IN "<unnamed cursor 1>";
NOTICE: PerformPortalFetch: portal "<unnamed cursor 1>" not found
FETCH 0
Why doesn't it find the cursor? Any ideas? Perhaps this isn't appropriate
for this mailing list, but I figured that I'd post it here anyhow since
ultimately I'm trying to get this to work with the JDBC.
Thanks in advance.
Regards,
Stuart
--
Stuart P. Robinson [stuart(at)zapata(dot)org]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Brett | 2002-07-02 12:44:10 | Re: Connection failed |
| Previous Message | Stuart Robinson | 2002-07-02 08:15:40 | Re: handling refcursors |