CRecordset::Open postgresql procedure call don't work
От | jeanclaude marzin |
---|---|
Тема | CRecordset::Open postgresql procedure call don't work |
Дата | |
Msg-id | 1528486456.1414195.1563182837204@wsfrf1420 обсуждение исходный текст |
Ответы |
Re: CRecordset::Open postgresql procedure call don't work
Re: CRecordset::Open postgresql procedure call don't work |
Список | pgsql-general |
Hi
I migrate from MSSQL to postgresql 11. I translate MSSQL stored procedure to Postgresql one :
CREATE PROCEDURE procacp ()
LANGUAGE SQL
AS $$
SELECT tabjdbexploit.jdbeid, tabjdbexploit.jdbeproc,
tabjdbexploit.jdbedate, tabjdbexploit.jdbetypemsg,
tabjdbexploit.jdbeurg, tabjdbexploit.jdbeconfid,
tabjdbexploit.jdbeetat, tabmsgacp.acpid,
tabmsgacp.acpnumserie,
tabmsgacp.acpsignserv, tabmsgacp.acpnumligne,
tabmsgacp.acpiaorigine, tabmsgacp.acpgdh,
tabmsgacp.acperv, tabmsgacp.acpcdu,
tabmsgacp.acpdir, tabmsgacp.acppere,
tabmsgacp.acpcomplement, tabmsgacp.acpsection
FROM tabjdbexploit INNER JOIN
tabmsgacp ON tabjdbexploit.jdbeid = tabmsgacp.acpid
ORDER BY tabjdbexploit.jdbedate ASC
$$;
All seems OK in PgAdmin 4, procedure is created
I use ODBC and Crecorset in C++
When i use the call strSQL = "{CALL procacp()}". It don't work :
Message error : ERROR: procacp() is a procedure
I don't know what to do
Thanks in advance for any assistance
Jean-Claude
I migrate from MSSQL to postgresql 11. I translate MSSQL stored procedure to Postgresql one :
CREATE PROCEDURE procacp ()
LANGUAGE SQL
AS $$
SELECT tabjdbexploit.jdbeid, tabjdbexploit.jdbeproc,
tabjdbexploit.jdbedate, tabjdbexploit.jdbetypemsg,
tabjdbexploit.jdbeurg, tabjdbexploit.jdbeconfid,
tabjdbexploit.jdbeetat, tabmsgacp.acpid,
tabmsgacp.acpnumserie,
tabmsgacp.acpsignserv, tabmsgacp.acpnumligne,
tabmsgacp.acpiaorigine, tabmsgacp.acpgdh,
tabmsgacp.acperv, tabmsgacp.acpcdu,
tabmsgacp.acpdir, tabmsgacp.acppere,
tabmsgacp.acpcomplement, tabmsgacp.acpsection
FROM tabjdbexploit INNER JOIN
tabmsgacp ON tabjdbexploit.jdbeid = tabmsgacp.acpid
ORDER BY tabjdbexploit.jdbedate ASC
$$;
All seems OK in PgAdmin 4, procedure is created
I use ODBC and Crecorset in C++
When i use the call strSQL = "{CALL procacp()}". It don't work :
Message error : ERROR: procacp() is a procedure
I don't know what to do
Thanks in advance for any assistance
Jean-Claude
В списке pgsql-general по дате отправления: