Devart Forums

I am using Devart ODBC driver for PostgreSQL 3.4.1 to connect to Postgres from Net Cobol. I can able to call a function successfully . But, when I try to invoke a stored procedure I am getting the following error message '[Devart][ODBC][PostgreSQL]vaowner.pkg_loa_company$add_loa_xref_vp9loaif(unknown, unknown) is a procedure. I could see for all the stored procedures, the parameter values as "unknowns" when I am invoking from Net COBOL. Is there any solution available?

Thanks,
Manoj

Hello,
To investigate this behavior of Devart ODBC Driver for PostgreSQL, we need a trace file from the ODBC Administrator utility.
To obtain it, please do the following:
- run the ODBC Administrator utility and navigate to the "Tracing" tab
- specify the path to the log file and its name (for example, DEVART.LOG)
- click the "Start Trace" button
- click the "Test connection" button
- run your software and perform the actions that lead to the error
- run the ODBC Administrator utility and go to the "Tracing" tab and click the "Stop Trace" button;
Send us the obtained log file DEVART.LOG
Please send us an example of calling a stored procedure in COBOL along with DDL scripts for creating stored procedures and tables in PostgreSQL.
Please send them through the form on our website: https://devart.com/company/contactform.html

wbr, Oleg
Devart Team