Getting Recordset through returning refcursor

From: "Kubilay Kaan" <heraklea(at)gmx(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Getting Recordset through returning refcursor
Date: 2019-11-15 10:06:32
Message-ID: trinity-76ffbba9-b396-4d9e-8edf-6828dc9e1b01-1573812392344@3c-app-gmx-bap40
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>Hello friends,</div>

<div>&nbsp;</div>

<div>I am not sure if I am right here bcz its my forst post so..</div>

<div>&nbsp;</div>

<div>I am using the&nbsp;Provider=MSDASQL.1 through psqlODBC as Data Source(created user DSN).</div>

<div>Postgresversion is 12.</div>

<div>Programming language is C++.</div>

<div>OS = Windows 10.</div>

<div>&nbsp;</div>

<div>So my problem is when I call a sql function which returns a refcursor for dynamic sql purposes it doesnt fill the recordset.</div>

<div>&nbsp;</div>

<div>So my question is does the ODBC driver supports refcursor??</div>

<div>&nbsp;</div>

<div>Is there any example/codesnippet or any sugestions? I did search alot abt this topic without success.</div>

<div>&nbsp;</div>

<div>&nbsp;</div>

<div>Thx in advance..</div></div></body></html>

Attachment Content-Type Size
unknown_filename text/html 891 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kubilay Kaan 2019-11-15 10:10:59 Getting Recordset through returning refcursor - second try(first has wrong format sorry)
Previous Message Peter Eisentraut 2019-11-15 09:43:07 Re: could not stat promote trigger file leads to shutdown