CRecordset::Open postgresql procedure call don't work

From: jeanclaude marzin <jeanclaude(dot)marzin(at)sfr(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: CRecordset::Open postgresql procedure call don't work
Date: 2019-07-15 09:27:17
Message-ID: 1528486456.1414195.1563182837204@wsfrf1420
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<span style="font-family:arial,helvetica,sans-serif">‌Hi<br>
I migrate from MSSQL to postgresql 11. I translate MSSQL stored procedure to Postgresql one :</span><br>
<br>
CREATE PROCEDURE procacp ()<br>
LANGUAGE SQL<br>
AS $$<br>
SELECT tabjdbexploit.jdbeid, tabjdbexploit.jdbeproc,<br>
&nbsp;&nbsp;&nbsp; tabjdbexploit.jdbedate, tabjdbexploit.jdbetypemsg,<br>
&nbsp;&nbsp;&nbsp; tabjdbexploit.jdbeurg, tabjdbexploit.jdbeconfid,<br>
&nbsp;&nbsp;&nbsp; tabjdbexploit.jdbeetat, tabmsgacp.acpid, &nbsp;<br>
&nbsp;&nbsp;&nbsp; tabmsgacp.acpnumserie,<br>
&nbsp;&nbsp;&nbsp; tabmsgacp.acpsignserv, tabmsgacp.acpnumligne,<br>
&nbsp;&nbsp;&nbsp; tabmsgacp.acpiaorigine, tabmsgacp.acpgdh,<br>
&nbsp;&nbsp;&nbsp; tabmsgacp.acperv,&nbsp; tabmsgacp.acpcdu,<br>
&nbsp;&nbsp;&nbsp; tabmsgacp.acpdir, tabmsgacp.acppere,<br>
&nbsp;&nbsp;&nbsp; tabmsgacp.acpcomplement, tabmsgacp.acpsection<br>
<br>
FROM tabjdbexploit INNER JOIN<br>
&nbsp;&nbsp;&nbsp; tabmsgacp ON tabjdbexploit.jdbeid = tabmsgacp.acpid<br>
<br>
ORDER BY tabjdbexploit.jdbedate ASC<br>
$$;<br>
<br>
<br>
<span style="font-family:arial,helvetica,sans-serif">All seems OK in PgAdmin 4, procedure is created<br>
<br>
I use ODBC and Crecorset in C++<br>
<br>
When i use the ca</span><span style="font-family:arial,helvetica,sans-serif; font-size:12px">ll </span>strSQL = "{CALL procacp()}". It don't work :<br>
<br>
Message error : ERROR: procacp() is a procedure<br>
<br>
I don't know what to do<br>
<br>
Thanks in advance for any assistance<br>
<br>
Jean-Claude

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fabio Pardi 2019-07-15 11:35:29 Re: help understanding pgbench results
Previous Message Luca Ferrari 2019-07-15 08:49:29 Re: How to run a task continuously in the background