returning refcursors (into Visual Basic)

From: "Erik Hjortsberg" <Erik_Hjortsberg(at)hermes(dot)ics(dot)lu(dot)se>
To: pgsql-odbc(at)postgresql(dot)org
Subject: returning refcursors (into Visual Basic)
Date: 2002-02-28 16:41:11
Message-ID: fc.000f45f30034b134000f45f30034b134.34b157@hermes.ics.lu.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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?

/erik hjortsberg

http://hysteriskt.viktigt.nu
http://www.ostgota.lu.se
http://come.to/erik.h

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Benoit Menendez 2002-02-28 18:48:43 Re: Case folding in DatabaseMetaData
Previous Message Jean-Michel POURE 2002-02-28 09:57:09 Re: [ODBC] Multibyte ODBC