<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

Reply via email to