From: | "ravi kiran" <ravysters(at)gmail(dot)com> |
---|---|
To: | pgsql-general-owner(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | Fwd: Returning Cursor |
Date: | 2008-08-04 12:20:43 |
Message-ID: | b634afa40808040520m43e12d80r7fd49da8618d09e9@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I am a developer working on postgres. I just wrote a function which ll
return a refcurosor as shown below.
CREATE OR REPLACE FUNCTION reffunc(refcursor)
RETURNS refcursor AS
$BODY$
BEGIN
OPEN $1 FOR SELECT * FROM SAM1;
RETURN $1;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100;
i have problems accessing this function from my middle tier i.e VC++.
I wrote a VC statement to retrieve values from this refcursor using a record
set. I cant access any of the values that the select statement in the
function should retrieve.When we executed the above function from VC we only
got the cursor name. We've been trying to access the values for the past one
week. Can you please help me by sending me a sample code as to how to get
the values in a recordset using this refcursor. Please do reply. This is
very urgent.
Thanks and regards
Ravi Kiran L
From | Date | Subject | |
---|---|---|---|
Next Message | ravi kiran | 2008-08-04 12:24:12 | Fwd: Returning Cursor |
Previous Message | ravi kiran | 2008-08-04 12:12:25 | Returning Cursor |