Re: returning refcursors (into Visual Basic) - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: returning refcursors (into Visual Basic)
Date
Msg-id 3C8406E1.520B8919@tpf.co.jp
Whole thread Raw
In response to returning refcursors (into Visual Basic)  ("Erik Hjortsberg" <Erik_Hjortsberg@hermes.ics.lu.se>)
List pgsql-odbc
Erik Hjortsberg wrote:
>
> Hello.
>
> I'm having some serious difficulties with making a function returning a
> recordset in the form of a refcursor to Visual Basic through pgODBC (or
> through pgAdminII).
> I'm using postgreSQL 7.2 and pgODBC 7.1.9
> I've tried with a function such as
>
> CREATE FUNCTION "returnCourse"("bpchar") RETURNS "refcursor" AS
> 'declare
>         _course ALIAS FOR $1;
>         _refcursor refcursor;
> begin
>         OPEN _refcursor FOR SELECT * FROM course where code = _course;
>         return _refcursor;
> end;
>
>         ' LANGUAGE 'plpgsql';
>
> But the only thing I get is a single value recordset with the string
> "<unnamed cursor 1>".
> Does anybody know what I'm doing wrong?

What your function returns is a reference to (name of)
a cursor and unfortunately there are few applications
which recognize "refcursor" and you have to call FETCH
commands using the cursor name to get the result.

regards,
Hiroshi Inoue

pgsql-odbc by date:

Previous
From: "Erik Hjortsberg"
Date:
Subject: returning refcursors (into Visual Basic)
Next
From: "Booth, Robert"
Date:
Subject: "This recordset is not updateable"