Message-ID: <gh-postgresql-interfaces-psqlodbc-134-c3266451093@github.com>
From: "AndreaLFR (@AndreaLFR)" <noreply+AndreaLFR@github.com>
To: "postgresql-interfaces/psqlodbc" <noreply+postgresql-interfaces-psqlodbc@github.com>
Date: Mon, 08 Sep 2025 13:54:12 +0000
Subject: Re: [postgresql-interfaces/psqlodbc] issue #134: Error in executing stored
In-Reply-To: <gh-postgresql-interfaces-psqlodbc-134@github.com>
References: <gh-postgresql-interfaces-psqlodbc-134@github.com>
List-Id: <gh-postgresql-interfaces-psqlodbc.github.com>
X-GitHub-Author-Login: AndreaLFR
X-GitHub-Comment-Id: 3266451093
X-GitHub-Comment-Type: issue_comment
X-GitHub-Edited-At: 2025-09-08T13:58:04Z
X-GitHub-Issue: 134
X-GitHub-Repo: postgresql-interfaces/psqlodbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/postgresql-interfaces/psqlodbc/issues/134#issuecomment-3266451093
Content-Type: text/plain; charset=utf-8

Hi, I'm sorry but I cannot do it... 
the ODBC-using program is written in Powerbuilder 12.6, using a standard ODBC connection to reach a PG 17 DB; the call is: 
		cExec = "CALL lomb_amb3_VERIFICA_1();"
		EXECUTE IMMEDIATE :cExec ;
		

I'm using only one db, only one session, only one connection, so by PgAdmin and ODBC.

The function has the variable "doppie_ricette" declared locally, and this name is never used elsewhere.

The very problems are:

    In the test cases, the query used in the cursor "doppie_ricette" never returns any row.

    If I execute - like all the processing data before this procedure - in the PgAdmin environment, everything goes well, without errors; but if I do this in a PowerBuilder (12.6) program, doing exactly the same steps, when I call this procedure I obtain the error. The sequence of operations (INSERTs, CALLs) is obviously the same, and it's on a unique connection on the same PG 17 DB.

I have done only one direct setting of the ODBC connection: "SET CLIENT_ENCODING TO 'UTF8'", for the rest the configuration of the ODBC is the original one.