refcursor error 55000

From: "Karen Hill" <karen_hill22(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: refcursor error 55000
Date: 2006-10-08 19:24:46
Message-ID: 1160335486.739295.120810@m73g2000cwd.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I get an error message 55000 when I try to traverse backwards in an
refcursor. Works fine going forward. The hint says I need to use
scroll. What is the syntax for using scroll in a stored procedure that
returns an refcursor? Or do refcursors only support traversing forward?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-10-08 20:48:48 Re: refcursor error 55000
Previous Message Matthew Peter 2006-10-08 19:04:01 Automatic locale detection?