Received-SPF: Pass (protection.outlook.com: domain of hcl.com designates
 192.8.195.59 as permitted sender) receiver=protection.outlook.com;
 client-ip=192.8.195.59; helo=APC01-HK2-obe.outbound.protection.outlook.com;
From: Prajakta Chinchole <prajakta.chinchole@hcl.com>
To: "pgsql-odbc@postgresql.org" <pgsql-odbc@postgresql.org>
Subject: RE: Support for PostgreSQL stored procedure through ITX. 
Thread-Topic: Support for PostgreSQL stored procedure through ITX. 
Thread-Index: Add02U6nNuFoCX1YR+a9/irsXTVLDgDxYhjA
Date: Wed, 14 Jul 2021 10:57:01 +0000
Message-ID: 
 <PS1PR04MB2758EB75CCCE871409A48C5E8B139@PS1PR04MB2758.apcprd04.prod.outlook.com>
References: 
 <SG2PR04MB27639019F5A557A68DCD80058B189@SG2PR04MB2763.apcprd04.prod.outlook.com>
In-Reply-To: 
 <SG2PR04MB27639019F5A557A68DCD80058B189@SG2PR04MB2763.apcprd04.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
Authentication-Results-Original: postgresql.org; dkim=none (message not
 signed) header.d=none;postgresql.org; dmarc=none action=none
 header.from=hcl.com;
X-Microsoft-Antispam-Message-Info-Original: 
 u+F3HLeolBg1squUz6rWKDZefkw4y289GqbqyiCsnXVvm66Jj4dctfv57ysOOUoyh1mezqpqQ9kyn82FLbQvlzhTVqceIPNE8BTtiNQDob+jvBhfXleNauw19x4dSAyYiPZzgT3r7W/zZXhpq0sRNwGv6Na9GbQI4OIy0jTWInMxz8I/htOeC7y8lLVwewy6XsXD9A5CzEemB35UBZWVxwlYGjxYZZBTJvbiPlmcm2WBZzIMBuXx+AaksVJK6FdIlwKfcV844l8fHsR16DDD7P4H+X0PPmSeTOr6s5fm1Ocm/zXl+Y/WIti8uem6oKxUyeyseKYQYLJj59NRVbQn6Nbg4MzGtcdPVkUKW1tHMV53JuUrC8OmBvKIX041mIG5b+tIG2bwgw0+jDeVOJOVkxXAFTydkL2NzV0DXkgZ+FCtdN0FutKw4+7nvD77Pobu1CnvlZEeKnNVum0se2dwLtm7F7YBKKz/nlGxDjpdehwmkhsE6xiwVc+KhxMtXC3rCmuhQluMB1hufcFbNM88ewjvrVIu0f9LI7Kt7q1I105rWFp4TUn8rmT5zjFriGyp63WcZcG2sCajsKbmAkcEsB6zScoxvnCd1ylaxxCAV1fUvbFhZ1r0Aq+5qwmd8VuawJlyyA21ZCnITWef9+zD0g8kzaIqBAeTutSaxbRTjdgRpXImUvRh7cv8XwfePbhpSqST28vYvRf8YJUOxoRL6Q==
X-Forefront-Antispam-Report-Untrusted: 
 CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:PS1PR04MB2758.apcprd04.prod.outlook.com;PTR:;CAT:NONE;SFS:(4636009)(346002)(39860400002)(396003)(366004)(376002)(136003)(5660300002)(4743002)(76116006)(52536014)(66946007)(2906002)(478600001)(316002)(8676002)(86362001)(7696005)(6506007)(66446008)(71200400001)(66476007)(64756008)(9686003)(33656002)(53546011)(66556008)(55016002)(44832011)(6916009)(186003)(8936002)(38100700002)(83380400001)(122000001)(38070700004);DIR:OUT;SFP:1102;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?nfnBz+zgRkwEJmdSQi/nz/ERZrL6JKpinZyI//OIEuf8ckYGV5qoop6MD8Hp?=
 =?us-ascii?Q?420khAtQQ3zsr+C0ibLlx4piCxmtd+E+YrLjwwu+ufhYdxIh2ZGB1L/VAi4P?=
 =?us-ascii?Q?el0MdjtmySAEf2Yvsx93aUTLLLuVlHZzPES9qo8dvNrRD3/11ZzZr4i9T6pn?=
 =?us-ascii?Q?hV3jlj0ySw22Uvc4vEp9tp+OsnSaAiPAIQanx1aNf1orQ3OEIqJYXmkIJ3Mi?=
 =?us-ascii?Q?J/jU5EZwpYpB7cnU7rgeri5zjslbFM0DVWMbsprd2LaKf0qn459VUgGxAeTg?=
 =?us-ascii?Q?WVAtM3emi5FMBxe43ELtlDNrYsYF0N8eBvzPcGfoILkW/59fOy2atYdZNh0Q?=
 =?us-ascii?Q?/u7aUwb80ZVSXXRY3nIyHUDmwGmpkiEzmD7LEvVblJrz7gG+RBtM/BjhQG8y?=
 =?us-ascii?Q?/cmpl0CIGRGsHOY8wuNIA/rYgtjG+fY38zAC7bVlFzCWLQMlsfF6fPJUdt0U?=
 =?us-ascii?Q?nQruylEJCPt6/oQMKOHOJGVBjIcZuQlDmfcyFYSGc1zuaDs9zBplQTeYrvWi?=
 =?us-ascii?Q?m60BZuOiF77ka00SVgIu6iKXzDmu7dGuLhG67kz6SUBrIgg+CQzR+gmiYZa0?=
 =?us-ascii?Q?t+B/z9eSp4W5Cyr7Aiu2hb3olgk89h4qlPuoZgOEOx2AdLATsLY7/+5bxSwP?=
 =?us-ascii?Q?2yXT5fMwuaT8bGMcDzLq6dYaqtFSdlxBToIBZyBF7ccX3Doj79uAKMwax7cg?=
 =?us-ascii?Q?6xVmasSZ3utTZzODy/nlYFi8/Cw7/9xabnLowxiu0FGGXWc69caw/FzAeU2+?=
 =?us-ascii?Q?BT0nhmXFzwcYyNvbAQT7/hhFpErNmsOBHbIiFOOH6eJ4El93MLL0WSdKlVcv?=
 =?us-ascii?Q?NnN5hxU/+Au6DCJpeNRMKkJ3cIwT1tRuHPQ/TcT8Ykk/4CPvV9nRSkR9iX0N?=
 =?us-ascii?Q?yGtJZUUUdsBejJZMMsZUuIwklXGLWbnhkXtv1WLfPNwfb8i9SYoQjRu0ObKX?=
 =?us-ascii?Q?3mZTGsk5D1mEOrUfVlcAleUxdUqjL2VbQ2Z2zEVoaw8x5wIoabF25uGkMtQB?=
 =?us-ascii?Q?nVcaWvcIUM3+FAYRiIEovdqp0+ki1pgmxR+4+cz1JwFkcPcQu73ox6mZwc+H?=
 =?us-ascii?Q?TmuiJqQULgGTAQuLiq7M9X9Wybj7j9AjbNwC2ja57a4X7hVM4BHgd2ltXwf9?=
 =?us-ascii?Q?zny1HBl1r1+lULEjGs7M8Hzphz4RT9YOua5n2BcH6pB3zHrSvxoS/50TJ4Uk?=
 =?us-ascii?Q?xs34h4D/GBjph7bIcZSz+3RXWWMXaY+dwzAAmj/kkkQGusdavB2MVgWwtVFc?=
 =?us-ascii?Q?/TR9Ee/oWSCwbp9ICXfWLlPuKZhycGNjp6AVDT9E1pnfQ/0O8L2v3Q6QT5r5?=
 =?us-ascii?Q?KzNFg357eJ6rEyryf3PHbh5fwjv4fG3HVoGF958NONYZVm3409mW28NGgzdR?=
 =?us-ascii?Q?N6MhB13+P+BjKkgj4O7H4lAPr3j9?=
x-ms-exchange-transport-forked: True
Content-Type: multipart/alternative;
	boundary="_000_PS1PR04MB2758EB75CCCE871409A48C5E8B139PS1PR04MB2758apcp_"
MIME-Version: 1.0
X-MS-Exchange-Transport-CrossTenantHeadersStamped: PSAPR04MB4200
X-DLP: MSGProcess
X-EOPAttributedMessage: 0
X-MS-Exchange-Transport-CrossTenantHeadersStripped: 
 PU1APC01FT025.eop-APC01.prod.protection.outlook.com
X-MS-Office365-Filtering-Correlation-Id-Prvs: 
	351f6a1f-a442-4880-35b9-08d946b61bd3
X-Microsoft-Antispam: BCL:0;
X-Microsoft-Antispam-Message-Info: 
	B/brNO3zfMUn2pflskPacOP2mZggOW4Ya3TfHly+y1vseN5UX/hZFJs0ZD/vx1M99Nm58BngMJJBs07Apzj9UFlefWQ2M2VehVPzYNoqApVzCFl42YIATJnO5ZGIqQ4hWFqIDDFCAGIHJxsvM9QEBTTc3BGoYjfBr1oJVhE4S7g4DvZ40Ci4eFxt2zOv3TEPaMymC0mJ6qAU5VZfQzet0OYTRvDMc24R8rRFB0YOBhHk3Yzp6MuB2v5YtqX5pO0ahxCx+zcoQvTW19gA/a9at2vAWcJ5h/IPTe1YgMVGvMI/DTWOe9zABhJROxcYNwEXhQ5RAqbovWfUqXzyCEQmx3p4cWFYeBfWAE3zChjU6PLEPe3lJzb3bs7RV2a37NCFhzbvxX7LX4vTsLuLPnoEZPKTIAtOMQZFYR+BXQsHwHCrFtztRWGPKGXbcSAysSlBz5uacB2jXIklS4IK/RKTQyF8ZKFYNe0yvRBWaBuZpAIT8CBzBLbgPM1ml0ofLhQ81tzICANcNxUbZmRmUA13MG6ZGhcJM0AAFPJnlBakSESug72IHAkbKddnGWG6VIyixawpWJYe9yjYTj7U12ii5QTYaNQePIt7oNdzzdgYsQ70NXJwG9gREgLXmz32htqBeYs2Oe3vZX5krh+ZoIl0eMYt01315SgYAFcAUuQ8HGoLFymPsfbmvmbN2gJTWhwvuIWF05nbDLHiMydkyZn1UR/LtL+FaFpZ6nyvddSpu5B8R1/XbQgBGHXfIGk+V7FmnoubiRSAt97bzpsTWyNNOA==
X-Forefront-Antispam-Report: 
	CIP:192.8.195.59;CTRY:IN;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:APC01-HK2-obe.outbound.protection.outlook.com;PTR:InfoDomainNonexistent;CAT:NONE;SFS:(4636009)(346002)(396003)(136003)(376002)(39860400002)(36840700001)(46966006)(186003)(70586007)(70206006)(36860700001)(356005)(478600001)(9686003)(34070700002)(26005)(53546011)(52536014)(83380400001)(33656002)(6506007)(8936002)(8676002)(36906005)(6916009)(316002)(7696005)(82740400003)(81166007)(44832011)(82310400003)(4743002)(86362001)(5660300002)(2906002)(47076005)(55016002)(336012)(36900700001);DIR:OUT;SFP:1102;
X-OriginatorOrg: HCL.COM
X-MS-Exchange-CrossTenant-OriginalArrivalTime: 14 Jul 2021 10:57:04.2137
 (UTC)
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 290d80e2-3653-4672-ad53-08d946b61dd2
X-MS-Exchange-CrossTenant-Id: 189de737-c93a-4f5a-8b68-6f4ca9941912
X-MS-Exchange-CrossTenant-OriginalAttributedTenantConnectingIp: 
 TenantId=189de737-c93a-4f5a-8b68-6f4ca9941912;Ip=[192.8.195.59];Helo=[APC01-HK2-obe.outbound.protection.outlook.com]
X-MS-Exchange-CrossTenant-AuthSource: 
	PU1APC01FT025.eop-APC01.prod.protection.outlook.com
X-MS-Exchange-CrossTenant-AuthAs: Anonymous
X-MS-Exchange-CrossTenant-FromEntityHeader: HybridOnPrem
X-MS-Exchange-Transport-CrossTenantHeadersStamped: SL2PR04MB3050
List-Id: <pgsql-odbc.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-odbc@lists.postgresql.org>
List-Owner: <mailto:pgsql-odbc-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-odbc>
Archived-At: 
 <https://www.postgresql.org/message-id/PS1PR04MB2758EB75CCCE871409A48C5E8B139%40PS1PR04MB2758.apcprd04.prod.outlook.com>
Precedence: bulk

--_000_PS1PR04MB2758EB75CCCE871409A48C5E8B139PS1PR04MB2758apcp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Any update on below issue ?

Thanks,
Prajakta Chinchole.

From: Prajakta Chinchole
Sent: Friday, July 9, 2021 9:15 PM
To: pgsql-odbc@postgresql.org
Subject: Support for PostgreSQL stored procedure through ITX.

Hello Team,

This is Prajakta from HCL-ITX team.

We are trying to execute a PostgreSQL stored procedure through ITX. We are =
using ODBC driver that was provided with PostgreSQL. We observed that sqlEx=
ecDirect() failed for stored procedure with below error :
               DIAG [42809] ERROR: public.transfer(integer, integer) is a p=
rocedure;
Error while executing the query (1)

We have verified all parameters passed to sqlExecDirect(). All are as expec=
ted and earlier bind call was also succeeded. We have collected odbc traces=
 generated for that run. Attached the same.

Could you please review the attached log and confirm why it was failing wit=
h ITX ?

Thanks,
Prajakta Chinchole.
Technical specialist - HCL.

::DISCLAIMER::
________________________________
The contents of this e-mail and any attachment(s) are confidential and inte=
nded for the named recipient(s) only. E-mail transmission is not guaranteed=
 to be secure or error-free as information could be intercepted, corrupted,=
 lost, destroyed, arrive late or incomplete, or may contain viruses in tran=
smission. The e mail and its contents (with or without referred errors) sha=
ll therefore not attach any liability on the originator or HCL or its affil=
iates. Views or opinions, if any, presented in this email are solely those =
of the author and may not necessarily reflect the views or opinions of HCL =
or its affiliates. Any form of reproduction, dissemination, copying, disclo=
sure, modification, distribution and / or publication of this message witho=
ut the prior written consent of authorized representative of HCL is strictl=
y prohibited. If you have received this email in error please delete it and=
 notify the sender immediately. Before opening any email and/or attachments=
, please check them for viruses and other defects.
________________________________

--_000_PS1PR04MB2758EB75CCCE871409A48C5E8B139PS1PR04MB2758apcp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;}
span.EmailStyle19
	{mso-style-type:personal-reply;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:10.0pt;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"#0563C1" vlink=3D"#954F72" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Any update on below issue ?<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Thanks,<o:p></o:p></p>
<p class=3D"MsoNormal">Prajakta Chinchole.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<div>
<div style=3D"border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in =
0in 0in">
<p class=3D"MsoNormal"><b>From:</b> Prajakta Chinchole <br>
<b>Sent:</b> Friday, July 9, 2021 9:15 PM<br>
<b>To:</b> pgsql-odbc@postgresql.org<br>
<b>Subject:</b> Support for PostgreSQL stored procedure through ITX. <o:p><=
/o:p></p>
</div>
</div>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Hello Team,<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">This is Prajakta from HCL-ITX team. <o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">We are trying to execute a PostgreSQL stored procedu=
re through ITX. We are using ODBC driver that was provided with PostgreSQL.=
 We observed that sqlExecDirect() failed for stored procedure with below er=
ror :
<o:p></o:p></p>
<p class=3D"MsoNormal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DIAG [42809] ERROR: public.transfer(intege=
r, integer) is a procedure;<o:p></o:p></p>
<p class=3D"MsoNormal" style=3D"text-indent:.5in">Error while executing the=
 query (1)<o:p></o:p></p>
<p class=3D"MsoNormal" style=3D"text-indent:.5in"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">We have verified all parameters passed to sqlExecDir=
ect(). All are as expected and earlier bind call was also succeeded. We hav=
e collected odbc traces generated for that run. Attached the same.
<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Could you please review the attached log and confirm=
 why it was failing with ITX ?<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Thanks,<o:p></o:p></p>
<p class=3D"MsoNormal">Prajakta Chinchole.<o:p></o:p></p>
<p class=3D"MsoNormal">Technical specialist &#8211; HCL. <o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<font face=3D"Arial" color=3D"Gray" size=3D"1">::DISCLAIMER::<br>
<hr>
The contents of this e-mail and any attachment(s) are confidential and inte=
nded for the named recipient(s) only. E-mail transmission is not guaranteed=
 to be secure or error-free as information could be intercepted, corrupted,=
 lost, destroyed, arrive late or
 incomplete, or may contain viruses in transmission. The e mail and its con=
tents (with or without referred errors) shall therefore not attach any liab=
ility on the originator or HCL or its affiliates. Views or opinions, if any=
, presented in this email are solely
 those of the author and may not necessarily reflect the views or opinions =
of HCL or its affiliates. Any form of reproduction, dissemination, copying,=
 disclosure, modification, distribution and / or publication of this messag=
e without the prior written consent
 of authorized representative of HCL is strictly prohibited. If you have re=
ceived this email in error please delete it and notify the sender immediate=
ly. Before opening any email and/or attachments, please check them for viru=
ses and other defects.<br>
<hr>
</font>
</body>
</html>

--_000_PS1PR04MB2758EB75CCCE871409A48C5E8B139PS1PR04MB2758apcp_--