Devart ODBC Driver-Invoking Stored Procedure from Net COBOL

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
Manoj91
Posts: 1
Joined: Tue 09 Mar 2021 09:40

Devart ODBC Driver-Invoking Stored Procedure from Net COBOL

Post by Manoj91 » Tue 09 Mar 2021 10:16

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

oleg0k
Devart Team
Posts: 190
Joined: Wed 11 Mar 2020 08:28

Re: Devart ODBC Driver-Invoking Stored Procedure from Net COBOL

Post by oleg0k » Wed 24 Mar 2021 15:21

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

Post Reply