not able to fetch from refcursor

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]

In response to

Responses

Browse pgsql-jdbc by date

  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