Hi, I am looking for a way to get the OUT parameters of a FUNCTION/PROCEDURE in my application (C++) using C libpq library. I can get the result set of an OUT parameter having REFCURSOR data type through an explicit FETCH ALL from "YYYY" but for OUT parameter of type integer/varchar I dont have a clue. Can anyone tell me how it is done or suggest any work around for this?
Using the following code I can get the refcursor.
CREATE OR REPLACE Function getAddresses ( pName IN varchar2, outCursor refcursor ) RETURN NUMBER IS BEGIN OPEN outCursor FOR SELECT * FROM "dummyTable" WHERE "name"=pName; return 1; END getAddresses;
strcat(statement, "SELECT getAddresses('abc', 'outcursor'); FETCH ALL IN outcursor"); res = PQexec(conn, statement); if (PQresultStatus(res) != PGRES_TUPLES_OK) { throw Exception(PQresultErrorMessage(res)); } cout << "Number of Rows: " << PQntuples(res) << " Number of Columns: " << PQnfields(res) << endl; PQclear(res);