Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iVZVO-0005Ts-8z for pgsql-interfaces@arkaria.postgresql.org; Fri, 15 Nov 2019 11:11:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iVZVL-0005Wl-QA for pgsql-interfaces@arkaria.postgresql.org; Fri, 15 Nov 2019 11:11:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iVZVL-0005We-FF for pgsql-interfaces@lists.postgresql.org; Fri, 15 Nov 2019 11:11:07 +0000 Received: from mout.gmx.net ([212.227.17.21]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iVZVI-0008E6-Sz for pgsql-interfaces@postgresql.org; Fri, 15 Nov 2019 11:11:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1573816261; bh=/gSm5YX/L67RFoyqef6gkuGKYMTGHKEMUP65Ruo/8rI=; h=X-UI-Sender-Class:From:To:Subject:Date; b=XpD3NSYiOCZOT1wlFz/hPegGYPIpDClRoqTeR7tswsdF5UdXpbd6YDcPuK/xZ7FkH Iy2zFjMEa5Qkb2JWifMThQ0bafwxsbLCWEGojsVc1unaRnd7m0T4GYZvn9/Tpouioa l0pfmUh6Mu3rmnQ32NgaRaNg92EkV9S6BJ75vdQQ= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from [46.252.139.211] ([46.252.139.211]) by web-mail.gmx.net (3c-app-gmx-bap61.server.lan [172.19.172.131]) (via HTTP); Fri, 15 Nov 2019 12:11:01 +0100 MIME-Version: 1.0 Message-ID: From: "Kubilay Kaan" To: pgsql-interfaces@postgresql.org Subject: Getting Recordset through returning refcursor Content-Type: text/html; charset=UTF-8 Date: Fri, 15 Nov 2019 12:11:01 +0100 Importance: normal Sensitivity: Normal X-Priority: 3 X-Provags-ID: V03:K1:kTba7tmRKac8vigcXdDFC0Lxy9KhYbqOW878np3c0vM19UyziDGKY6Z7RW1NkDs7xxM3i fb3T1DWOlT+Bt11602x4Goi+fgDOPqQY2z1umT5rNjQXtA6YpRa/InBzF6MKyM96t//o7eCFWU46 KdOMLUOggmKjrgQMGFI4HZx1q3wXURyiDXUaWnk6uOa0VfjZNat0FjzmgCoaqDsTvzq06VrfrewE uj5/+vvRqcErHk6zNwbSf8Z02SYEeK14PEgjF8aXy2XPEPBeaxldhsgJqrOgYyGIaL8qk3Xp+YGZ BI= X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:dAwO/FnY0bE=:z0Z2/53o/hTEURtZBVzfoU JYSFCMMGQqggGTz3ohF6AG3e+7AQNbIL8YTSYxSoe1fRnQfyyP3rZJhU8wN5eKnU7uC5Plm+4 ZeWvAbmUlutGu6PRt98TtlSdSm08+5xzc+cbhacURhxywOsIyvColZhmKr/3pBFwHvoFg8OK6 UXRCgzgzOHlFOba4b+PExtfMfBUPWGjpLTorzjiIelCnbOJ9gvHQpt1HkEO5oPBOvru+9puj+ tjqwkTJzv1acOLYFA6FXzGPXJqFVMgQu+mTnM9LJyGWJK+8JOoy9142O1fo/KMkkglZP4ocl6 O7/eg3jrRECcjZy518SrDMi+5bwOy4FBnkkaf2DaiyXJ1pAfHwSaVNVhpyYrbRocPvgFTF3dj WqqQoJalQOSsucqOH5SjYEk/rFRlmQEJDROHFws79LakVHLRhKhW/GoWwFqAUe8IN/Qavnou1 nJcV/ZfrE3RyIb1i5yTzijlFltCazR9RyzO8mzv7vCNjR1UDK0Hjmb+MvNpYLD8zxsm4e3ZCs HplEBSmj8ZpVPjb1b2uyF2XJA/0LUnXP49i4X9D6zk03RuJLi/lWrCF+jkKyy8RGbw7afUiMj hieT72t/ObkRIh9+ZKH2LU7+8pPYZkMWWDbus4G1EFCb1iy1bo5VUh0DmsG0RjD4iR+CTtSML jySxlyXV4ztTcTxfzbJFN8NxCHW2PBv4tDBu+TiX7NLfIAg== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk

Hello friends,

I am using the Provider=MSDASQL.1 through psqlODBC as Data Source(created user DSN).
Postgresversion is 12.
Programming language is C++.
OS = Windows 10.

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

So my question is does the ODBC driver supports refcursor??

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

Thx in advance..