res = PQexec(conn,"BEGIN");
PQClear(res);
res = PQexec(conn,"DECLARE myportal cursor for select * from test");
PQClear(res);
res= PQexec(conn,"FETCH ALL IN myportak");
----
---USE THE RESULT SET
-------
PQClear(res);
res = PQexec(conn,"END");
PQClear(res);
chiragvaghela 0 Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.