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: | Raw Message | Whole Thread | 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 |