Returning Cursor
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
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
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
ravi kiran wrote:
Hello,
I am a developer working on postgres. I just wrote a function which ll
return a refcurosor as shown below.
[snip]
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.
Please show us your code. Also, what access method are you using? "VC"
isn't a database access method. Are you using libpq? ODBC? LINQ?
--
Craig Ringer